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 = 'EN-GB')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 = 2,sd.langue = 'EN-GB')或(`sda`.association = 'NoModel' AND sd.state = 1 AND sd.link_file!= ''和sd.link_file IS NOT NULL和sd.langue = 'EN-GB' AND sd.catalogue = 2))GROUP BY sd.id ORDER BY sd.is_general_catalog DESC,ASC sdc.ordering,sd.ordering ASC