INSERT INTO procs set name='5.5. Liste des lecteurs d\'un panier', requete='SELECT libelle_groupe as Groupe, concat(empr_nom, \' \', empr_prenom) as Lecteur, empr_cb as \'Numéro\', libelle as \'Catégorie\' FROM empr, empr_categ, empr_groupe, groupe, empr_caddie_content WHERE empr_caddie_id in (!!caddie!!) and object_id=empr_id and id_categ_empr=empr_categ and id_empr = empr_id and groupe_id = id_groupe GROUP BY empr_cb ORDER BY groupe, empr_nom, empr_prenom', comment='', autorisations='1', parameters='<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
<FIELDS>
 <FIELD NAME=\"caddie\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Panier]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY>SELECT idemprcaddie, name FROM empr_caddie order by name</QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
</FIELDS>'