La famille de 4 infuseurs Mr Tea

SELECT *, P.id as id, P.id as idproduit, CGL.title as titregroupe, CL.seo_permalink as uricategorie, PL.title as nomproduit, CL.title as titrecategorie, C.id as idcategorie, CL.seo_title as seo_title_category, CL.seo_meta_description as seo_meta_description_category, CL.text as textcategorie, PCL.title as titrecategorieproduit FROM smtbl_categories_multilingual CL LEFT JOIN smtbl_categories C ON C.id = CL.id_category LEFT JOIN smtbl_categories_groups CG ON CG.id = C.id_category_group LEFT JOIN smtbl_categories_groups_multilingual CGL ON CGL.id_category_group = C.id_category_group LEFT JOIN smtbl_products_categories PC ON PC.id_category = C.id LEFT JOIN smtbl_categories CP ON CP.id = PC.id_category LEFT JOIN smtbl_categories_multilingual PCL ON PCL.id_category = CP.id LEFT JOIN smtbl_categories_groups CG2 ON CG2.id = CP.id_category_group LEFT JOIN smtbl_products P ON P.id = PC.id_product LEFT JOIN smtbl_products_multilingual PL ON PL.id_product = P.id LEFT JOIN smtbl_images_relations IR ON IR.id_item = P.id AND IR.id_module =3 AND IR.id_image = P.couverture LEFT JOIN smtbl_images I ON I.id = IR.id_image LEFT JOIN smtbl_pdj pdj ON pdj.product_id = P.id AND pdj.date = CURDATE() WHERE C.id IN (148) AND PL.id_language='1' AND C.id_category_group != 17 AND C.id_category_group != 15 GROUP BY P.id ORDER BY rand() LIMIT 3