SELECT concat( date_format(current_date , '%d/%m/%Y'), ", Bilan des emprunts pour : ",' ',empr_nom,' ',empr_prenom, ", empr_cb :", '!!num_lecteur!!') as "Date et nom" from empr where empr_cb = '!!num_lecteur!!'; SELECT arc_debut as "Date emprunt" , arc_fin as "Date retour" ,arc_expl_cote as "Cote",  expl_cb as "Code-barres", tit1 as "Titre notice", bulletin_titre as "Titre bulletin" FROM (pret_archive,empr,exemplaires LEFT JOIN notices ON expl_notice= notice_id)  LEFT JOIN bulletins ON expl_bulletin = bulletin_id WHERE empr_cb = '!!num_lecteur!!' AND id_empr = arc_id_empr AND arc_expl_id= expl_id ORDER BY date(arc_debut)