INSERT INTO procs set name='2.6. Nombre de prêts par auteur', requete='SELECT author_name AS \"Nom\", author_rejete AS \"Prénom\", count(arc_id) AS \"Nombre de prêts\" FROM authors a, responsability r, exemplaires e, notices n, pret_archive pa WHERE a.author_id=r.responsability_author AND r.responsability_notice=n.notice_id AND n.notice_id=e.expl_notice AND pa.arc_expl_id=e.expl_id AND date(pa.arc_debut) BETWEEN \"!!Du!!\" AND \"!!Au!!\" GROUP BY author_id ORDER BY 3 desc', comment='Recherche entre deux dates', 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>
</FIELDS>'