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 = 1 AND 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 = 1））GROUP BY sd.id ORDER BY sd.is_general_catalog DESC，ASC sdc.ordering，sd.ordering ASC