INSERT INTO procs set name='3.4. Liste des titres jamais empruntés, par section (sauf périodiques)', requete='SELECT distinct tit1 as \"Titre\", CONCAT(\"\'\",expl_cb,\"\'\") as \'Code-barres\', expl_cote as \"Cote\" FROM notices, docs_section, exemplaires LEFT JOIN pret_archive ON expl_notice=arc_expl_notice WHERE (date(arc_debut) not between \"!!Du!!\" and \"!!Au!!\" and date(arc_fin) not between  \"!!Du!!\" and \"!!Au!!\" or arc_expl_notice is null) AND expl_notice=notice_id AND expl_section=idsection AND idsection IN(!!Section!!) ORDER BY expl_cote, tit1', comment='Recherche entre deux dates, tri par cote et titre', autorisations='1', parameters='<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
<FIELDS>
 <FIELD NAME=\"Du\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Du]]></ALIAS>
  <TYPE>date_box</TYPE>
<OPTIONS FOR=\"date_box\"></OPTIONS>
 </FIELD>
 <FIELD NAME=\"Au\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Au]]></ALIAS>
  <TYPE>date_box</TYPE>
<OPTIONS FOR=\"date_box\"></OPTIONS>
 </FIELD>
 <FIELD NAME=\"Section\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Section]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY><![CDATA[SELECT idsection, section_libelle FROM docs_section ORDER BY 2]]></QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
</FIELDS>'