INSERT INTO procs set name='3.3. Liste des titres les plus empruntés, par genre (sauf périodiques)', requete='SELECT distinct tit1 AS \"Titre\",count(arc_id) AS \"Nombre de prêts\" FROM exemplaires e, notices n, notices_custom_values ncv, notices_custom_lists ncl, notices_custom nc, pret_archive pa WHERE n.notice_id=e.expl_notice AND n.notice_id = ncv.notices_custom_origine AND ncv.notices_custom_champ=nc.idchamp AND nc.idchamp = ncl.notices_custom_champ AND nc.idchamp = 2 AND ncv.notices_custom_integer=ncl.notices_custom_list_value AND e.expl_id=pa.arc_expl_id AND ncl.notices_custom_list_value=\'!!Genre!!\' AND date(arc_debut) BETWEEN \"!!Du!!\" AND \"!!Au!!\" GROUP BY 1 ORDER by 2 desc', comment='Recherche entre deux dates', autorisations='1', parameters='<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
<FIELDS>
 <FIELD NAME=\"Genre\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Genre]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY><![CDATA[SELECT notices_custom_list_value, notices_custom_list_lib FROM `notices_custom_lists` WHERE notices_custom_champ =2 ORDER BY notices_custom_list_lib]]></QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
 <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>
</FIELDS>'