string(749) "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 = 10 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 = 43)) AND ct.id_lang = 10 AND ct.approved =1 ORDER BY ct.date_sent DESC limit 100" string(749) "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 = 10 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 = 43)) AND ct.id_lang = 10 AND ct.approved =1 ORDER BY ct.date_sent DESC limit 100" Testimonials | HumidorDiscount

Rekomendacje