PRODUITS德LABORATOIRE
SELECT sd.id,sd.lng_parent,sd.title,sd.image,sd.link_file,sd.catalogue AS doc_catalogue,sd.langue AS doc_langue,sdc.title AS categorie,sdc.id AS categorie_id,sg.title AS gamme_title,sg.id AS gamme_id,sda.id_association AS id_modele FROM #__socorex_documents AS SD LEFT JOIN #__socorex_documents_cats AS SDC ON(sdc.lng_parent = sd.id_categorie AND sdc.langue = 'FR-FR')LEFT JOIN #__socorex_documents_associations AS SDA ON(sda.id_document = sd.lng_parent)LEFT JOIN #__socorex_gammes AS SG ON sg.lng_parent = sda.gamme WHERE((sd.state = 1 AND sd.link_file!= '' AND sd.link_file IS NOT NULL和sg.state= 1 AND sdc.state = 1 AND sd.catalogue = 1 AND sd.langue = 'FR-FR')OR(`sda`.association = 'NoModel' AND sd.state = 1 AND sd.link_file!= ''AND sd.link_file IS NOT NULL AND sd.langue = 'FR-FR' AND sd.catalogue = 1))GROUP BY sd.id ORDER BY sd.is_general_catalog DESC,sdc.ordering ASC,ASC sd.ordering

Filtrer面值

Réinitialiser吹捧
  • 文件
  • FILTRER PAR索绪尔
  • VIDÉOTHÈQUE
  • PRODUITS相提并论familles
RECHERCHER