X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=inclure%2Fliste_gis.html;h=5741d26757063afa47349554116722fb6fa61f8c;hb=9195cd1033f4d302a0f861a86f5525fedbebbc04;hp=aca42171d81d0afdf58d50e846bffb60cc4dbc5e;hpb=6e5d0cc49675526859f078a0493fcb47bfefb214;p=lhc%2Fweb%2Fspip_carte_de_sites.git diff --git a/inclure/liste_gis.html b/inclure/liste_gis.html index aca4217..5741d26 100644 --- a/inclure/liste_gis.html +++ b/inclure/liste_gis.html @@ -1,15 +1,24 @@ - -#SET{req_gis,#VAL{"SELECT DISTINCT spip_gis.*, spip_syndic.* 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{"' AND spip_gis.region='"}|concat{#ENV{ma_region}}|concat{"' ORDER BY spip_gis.ville"}} +#SET{req_gis,#VAL{"SELECT DISTINCT spip_gis.*, spip_syndic.* 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{"' AND spip_gis.region='"}|concat{#ENV{ma_region}}|concat{"' ORDER BY spip_gis.ville"}}