SELECT r.*, fn.value as firstname, ln.value as lastname FROM `magentopagereview` r inner join magentocustomer_entity c on r.customer_id = c.entity_id inner join magentocustomer_entity_varchar fn ON c.entity_id = fn.entity_id inner join magentocustomer_entity_varchar ln ON c.entity_id = ln.entity_id where listing_id = 1703 AND fn.attribute_id = 5 AND ln.attribute_id = 7 and status = 1 order by r.created_at desc



Restaurants à proximité

Métis Brasserie by Crystal Casa

Eden By Crystal Casablanca

Aux Crevettes Restaurant-Lounge

Hotel Club Val d'Anfa

Legal Disclaimer

In an attempt to provide increased value to our visitors, may provide links, phone numbers, and other methods of contact to websites / businesses operated by third parties. However, even if the third party is affiliated with, has no control over these linked websites / businesses, all of which have separate privacy policies and business practices, independent of These linked websites / businesses are only for your convenience and therefore you access them at your own risk. assumes no responsibility whatsoever for any damage or negative consequences that may occur as a result of contacting or utilizing these websites / businesses.