选择sd。id, sd。lng_parent, sd。标题、sd。形象,sd。link_file, sd。目录为doc_catalogue, sd。如doc_langue, sdc。标题作为类别,sdc。id为categories e_id, sg。标题为gamme_title, sg。id = gamme_id, sda。id_association作为id_modele从#剩余的socorex_documents作为sd左加入#剩余的socorex_documents_cats作为sdc ON (sdc)。lng_parent = sd。id_categorie和质素。左加入#剩余socorex_documents_associations作为sda ON (sda。id_document = sd。左加入#剩余的socorex_gammes作为sg上的sg。lng_parent = sda。(sd)。国家= 1和sd。link_file != '' AND sd.link_file IS NOT NULL AND sg.state=1 AND sdc.state=1 AND sd.catalogue = 2 AND sd.langue = 'en-GB' ) OR ( `sda`.association = 'NoModel' AND sd.state = 1 AND sd.link_file != '' AND sd.link_file IS NOT NULL AND sd.langue = 'en-GB' AND sd.catalogue = 2 ) ) GROUP BY sd.id ORDER BY sd.is_general_catalog DESC, sdc.ordering ASC , sd.ordering ASC