inclure/requete_pays.html

   1 #SET{req_pays,"SELECT spip_gis.pays FROM spip_mots, spip_mots_liens, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type = 'Ateliers' AND spip_mots_liens.objet = 'site' AND spip_mots_liens.id_objet = spip_syndic.id_syndic AND spip_syndic.id_syndic = spip_gis_liens.id_objet AND spip_gis.id_gis = spip_gis_liens.id_gis AND spip_gis_liens.objet = 'site' GROUP BY spip_gis.pays"}
   2
   3 <BOUCLE_sql(DATA){source sql, #GET{req_pays}}>
   4     <INCLURE{fond=inclure/liste_pays}{ajax}{env}{mon_pays=#PAYS}>
   5 </BOUCLE_sql>