INSERT INTO procs set name='7.5. Liste des termes des champs personnalisables', requete='SELECT l.notices_custom_list_lib as \"Libellé\", count(DISTINCT v.notices_custom_origine) as \"Nombre de notices\" FROM notices_custom_lists l LEFT JOIN notices_custom_values v ON v.notices_custom_integer = l.notices_custom_list_value AND v.notices_custom_champ = l.notices_custom_champ WHERE l.notices_custom_champ=!!Nom_du_champ!! GROUP BY l.notices_custom_list_lib ORDER by l.notices_custom_list_lib', comment='Termes de la liste et nombre de notices contenant chaque terme', autorisations='1', parameters='<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
<FIELDS>
 <FIELD NAME=\"Nom_du_champ\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Champ personnalisable]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY>SELECT idchamp, titre FROM notices_custom WHERE type=\'list\' ORDER BY titre</QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
</FIELDS>'