INSERT INTO procs set name='test_basic_liste_emprunt_iso', requete='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)', comment='Test  pour Celine en iso', autorisations='1', parameters='' #charset=iso-8859-1