string(746) "SELECT ct.*,c.firstname,SUBSTRING(c.lastname,1,1) lastname,ct2.testimonial testimonial_original,ct2.id_lang lang_original, ll.name name_lang_original FROM `ps_custom_testimonial` ct INNER JOIN ps_customer c ON c.id_customer = ct.id_customer LEFT JOIN ps_custom_testimonial ct2 ON ct2.id_testimonial = ct.id_parent_testimonial LEFT JOIN ps_lang_lang ll ON ll.id_lang = ct2.id_lang AND ll.lang = 1 WHERE ct.id_shop IN (SELECT id_shop FROM ps_shop WHERE id_shop_group = (select id_shop_group FROM ps_shop WHERE id_shop = 7)) AND ct.id_lang = 1 AND ct.approved =1 ORDER BY ct.date_sent DESC limit 100" string(746) "SELECT ct.*,c.firstname,SUBSTRING(c.lastname,1,1) lastname,ct2.testimonial testimonial_original,ct2.id_lang lang_original, ll.name name_lang_original FROM `ps_custom_testimonial` ct INNER JOIN ps_customer c ON c.id_customer = ct.id_customer LEFT JOIN ps_custom_testimonial ct2 ON ct2.id_testimonial = ct.id_parent_testimonial LEFT JOIN ps_lang_lang ll ON ll.id_lang = ct2.id_lang AND ll.lang = 1 WHERE ct.id_shop IN (SELECT id_shop FROM ps_shop WHERE id_shop_group = (select id_shop_group FROM ps_shop WHERE id_shop = 7)) AND ct.id_lang = 1 AND ct.approved =1 ORDER BY ct.date_sent DESC limit 100" Testimonials | Agnato

Testimonials