select lender_libelle as Propriétaire, location_libelle as Localisation, section_libelle as Section, statut_libelle as Statut, expl_cote as Cote, CASE WHEN expl_notice>0 THEN concat(CASE WHEN serie_name IS NOT NULL THEN CONCAT(serie_name, " : ") ELSE "" END, n1.tit1) ELSE CONCAT(n2.tit1," ",bulletin_numero," ") END as Titre, if(a0.author_id is not null,CONCAT(a0.author_name, ' ', a0.author_rejete),'') as 'Auteur principal', ed_name as Editeur, n1.year as "Année d'édition", expl_cb as "Code-barres", expl_prix as Prix from exemplaires left join notices n1 on expl_notice=n1.notice_id left join series on n1.tparent_id=serie_id left join bulletins on expl_bulletin=bulletin_id left join notices n2 on bulletin_notice=n2.notice_id left join docs_location on expl_location=idlocation left join docs_section on expl_section=idsection left join publishers on n1.ed1_id=ed_id left join responsability as r0 on (n1.notice_id=r0.responsability_notice and r0.responsability_type=0) left join authors as a0 on a0.author_id=r0.responsability_author left join docs_statut on expl_statut=idstatut left join lenders on expl_owner=idlender where idsection in (!!sections!!) and expl_owner=!!preteur!! order by section_libelle, expl_cote, expl_cb