Les clients ayant consulté cet article ont également regardé ces fiches
SELECT `A`.*, `C`.*, `COM`.*, `SI`.*, `SIZG`.*, `SIZGL`.*, `CO`.`DT_EXPE` FROM `avis` AS `A`
INNER JOIN `client` AS `C` ON A.ID_CLIE = C.ID_CLIE
INNER JOIN `commande` AS `COM` ON COM.ID_COMM = A.ID_COMM
INNER JOIN `site_internet` AS `SI` ON A.ID_SITEINTE = SI.ID_SITEINTE
INNER JOIN `siteinte_zonegeog` AS `SIZG` ON SIZG.ID_SITEINTE = SI.ID_SITEINTE
INNER JOIN `siteintezonegeog_lang` AS `SIZGL` ON SIZGL.ID_SITEINTEZONEGEOG = SIZG.ID_SITEINTEZONEGEOG
LEFT JOIN `commande` AS `CO` ON A.ID_COMM = CO.ID_COMM WHERE (A.BL_ACTI = 1) AND (SI.CD_SITEINTE = 'FENIMULT') AND (A.CD_AVISVERI IS NOT NULL) AND (A.ID_PROD = 529) ORDER BY `A`.`DT_AVIS` DESC