Trier par démonstrateur SELECT id_dossier_particip, cf.id_conferencier, nom, prenom, societe, fonction, edito_long, tel, fax, mail, logo, photo, web, edito_expert FROM conferenciers cf, contacts c LEFT JOIN event_contact_cycle ecc ON c.id_contact=ecc.id_contact WHERE c.id_contact=cf.id_contact AND cf.id_event IN ('1316') AND cf.statut IN ('sponsor', 'soutien', 'soutient_demonstrateur', 'exposant','partenaire_national','partenaire_institutionnel') AND cf.afficher = 'y' AND ( (cf.id_conf_event IN ( SELECT id_conf_event FROM conf_event_event_cycle_lang WHERE id_event_cycle_lang='5692')) OR (ecc.id_event_cycle_lang='5692') OR cf.id_conferencier IN (SELECT id_conferencier FROM conferencier_communaute WHERE id_communaute='5692') OR cf.id_conferencier IN (SELECT id_conferencier FROM conferencier_communaute WHERE id_communaute IN (SELECT id_event_cycle_lang FROM event_cycle_lang WHERE id_event_child='5692')) ) GROUP BY c.id_contact ORDER BY ordre_affichage+1 DESC, societe, nom

A découvrir prochainement