INSERT INTO procs set name='4.6. Liste des exemplaires par propriétaire et par section (sauf périodiques)', requete='select section_libelle as \'Section\', expl_cote as \'Cote\', CONCAT(\"\'\",expl_cb,\"\'\") as \'Code-barres\', tit1 as \'Titre\' from exemplaires, notices, docs_section, lenders where idsection in (!!sections!!) and expl_owner=!!proprietaire!! and expl_notice=notice_id and expl_section=idsection and expl_owner=idlender order by section_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=\"sections\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Section(s)]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY>select idsection, section_libelle from docs_section ORDER BY section_libelle</QUERY>
 <MULTIPLE>yes</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><![CDATA[select idlender, lender_libelle from lenders order by idlender]]></QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
</FIELDS>'