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

Commentaires

Sponsored

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, Hmizate.ma 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 Hmizate.ma, Hmizate.ma has no control over these linked websites / businesses, all of which have separate privacy policies and business practices, independent of Hmizate.ma. These linked websites / businesses are only for your convenience and therefore you access them at your own risk. Hmizate.ma assumes no responsibility whatsoever for any damage or negative consequences that may occur as a result of contacting or utilizing these websites / businesses.