SELECT expl_cb as "Code-Barre", notices.year as "Année d'édition", tit1 as Titre, expl_cote as Cote, GROUP_CONCAT(author_name, ' ', author_rejete ORDER BY responsability_type SEPARATOR ', ') as "Auteur(s)",ed_name as Editeur, expl_prix as Prix, lender_libelle as Propriétaire, statut_libelle AS Statut, location_libelle as Localisation,codestat_libelle as Codestat, tdoc_libelle as Support, section_libelle as Section FROM exemplaires JOIN lenders ON idlender=expl_owner join docs_type on expl_typdoc=idtyp_doc JOIN docs_location ON idlocation= expl_location JOIN docs_codestat ON idcode=expl_codestat JOIN docs_section ON idsection=expl_section JOIN docs_statut ON idstatut=expl_statut JOIN notices ON expl_notice=notice_id JOIN responsability ON (responsability_notice=notice_id AND responsability_type=0) JOIN authors ON author_id=responsability_author JOIN publishers ON ed1_id=ed_id WHERE expl_location IN (!!locationn!!) AND expl_section IN (!!sectionn!!) AND expl_codestat IN (!!codestatt!!) AND expl_typdoc IN (!!typdocc!!) AND expl_owner IN (!!proprioo!!) AND expl_statut IN (!!statutt!!) GROUP BY expl_id ORDER BY Propriétaire, Localisation, Codestat, Support, Section, Statut, 1