X-Git-Url: https://git.heureux-cyclage.org/?p=lhc%2Fweb%2Fspip_carte_de_sites.git;a=blobdiff_plain;f=inclure%2Frequete_regions.html;h=0966812e98e9fe46065406436b6aa3d6fa800ead;hp=6a67497d4b3fb653e9484d0e9e79142d2afa166f;hb=d53a8523f3d8f8dbec201b236f8cfbab4b0e5366;hpb=6e5d0cc49675526859f078a0493fcb47bfefb214

diff --git a/inclure/requete_regions.html b/inclure/requete_regions.html
index 6a67497..0966812 100644
--- a/inclure/requete_regions.html
+++ b/inclure/requete_regions.html
@@ -1,4 +1,4 @@
-#SET{req_regions,#VAL{"SELECT spip_gis.region 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' AND spip_gis.pays='"}|concat{#ENV{mon_pays}}|concat{"' GROUP BY spip_gis.region"}}
+#SET{req_regions,#VAL{"SELECT spip_gis.region 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' AND spip_gis.pays='"}|concat{#ENV{mon_pays}}|concat{"' GROUP BY spip_gis.region"}}
 
 <BOUCLE_sql(DATA){source sql,#GET{req_regions}}>
     <INCLURE{fond=inclure/liste_regions}{ajax}{env}{ma_region=#REGION}>