INSERT INTO procs set name='3.2. Liste des titres les plus empruntés, par section (sauf périodiques)', requete='SELECT section_libelle as Section,IF(CONCAT(tit1, \" / \", author_name, \", \", author_rejete) IS NULL, tit1, CONCAT(tit1, \" / \", author_name, \", \", author_rejete)) AS \'Titre / Auteur\', COUNT(*) AS \'Nombre de prêts\' FROM ((pret_archive left join notices on arc_expl_notice=notice_id left join docs_section on arc_expl_section=idsection LEFT JOIN responsability ON notice_id = responsability_notice AND responsability_type=0) LEFT JOIN authors ON responsability_author = author_id) WHERE arc_expl_section in (!!choixsection!!) and date(arc_debut) BETWEEN \"!!Du!!\" AND \"!!Au!!\" and notice_id is not null GROUP BY arc_expl_notice ORDER BY 3 desc', comment='Recherche entre deux dates', autorisations='1', parameters='<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
<FIELDS>
 <FIELD NAME=\"choixsection\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Choisissez une ou plusieurs sections :]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY><![CDATA[select idsection, section_libelle from docs_section order by 2]]></QUERY>
 <MULTIPLE>yes</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>'