INSERT INTO procs set name='4.7. Liste des exemplaires par propriétaire et  par statut (sauf périodiques)', requete='select statut_libelle AS \"Statut\", expl_cote AS \"Cote\", CONCAT(\"\'\",expl_cb,\"\'\") AS \"Code-barres\", tit1 AS \"Titre\" from exemplaires, notices, docs_statut, lenders where expl_statut=!!statut!! and expl_owner=!!Proprietaire!! and expl_notice=notice_id and expl_statut=idstatut and expl_owner=idlender order by lender_libelle, statut_libelle, expl_cote, expl_cb ', comment='Titres triés par cote et code-barres', autorisations='1', parameters='<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
<FIELDS>
 <FIELD NAME=\"statut\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Statut]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY>select idstatut, statut_libelle from docs_statut ORDER BY statut_libelle</QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
 <FIELD NAME=\"Proprietaire\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Propriétaire]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY>select idlender, lender_libelle from lenders</QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
</FIELDS>'