inclure/requete_regions.html

   1 #SET{req_regions,#VAL{#ENV{groupe}|?{}|concat{"SELECT spip_gis.region FROM spip_mots,spip_mots_liens, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type='",#ENV{groupe}, "' 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' AND spip_gis.pays='", #ENV{mon_pays}, "' GROUP BY spip_gis.region"}}}
   2
   3 <BOUCLE_sql(DATA){source sql,#GET{req_regions}}>
   4     <INCLURE{fond=inclure/liste_regions}{ajax}{env}{ma_region=#REGION}>
   5 </BOUCLE_sql>