X-Git-Url: http://git.cyclocoop.org/?p=lhc%2Fweb%2Fspip_carte_de_sites.git;a=blobdiff_plain;f=inclure%2Frequete_pays.html;fp=inclure%2Frequete_pays.html;h=86a37c8887e08a63a87e610bfa93e6f5c4374985;hp=0000000000000000000000000000000000000000;hb=67135bf6e346aaac4d73170639e2af9172fa7d0d;hpb=8d8d050a85adbd0b345083e09e602c1c94c0fff5

diff --git a/inclure/requete_pays.html b/inclure/requete_pays.html
new file mode 100644
index 0000000..86a37c8
--- /dev/null
+++ b/inclure/requete_pays.html
@@ -0,0 +1,5 @@
+#SET{req_pays,"SELECT spip_gis.pays FROM spip_mots, spip_mots_syndic, spip_syndic, spip_gis, spip_gis_liens WHERE spip_mots.type='Ateliers' AND spip_mots_syndic.id_syndic=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='syndic'  GROUP BY spip_gis.pays"}
+
+<BOUCLE_sql(DATA){source sql, #GET{req_pays}}>
+    <INCLURE{fond=inclure/liste_pays}{ajax}{env}{mon_pays=#PAYS}>
+</BOUCLE_sql>
\ No newline at end of file