River-Guides



847
rivers

( 1504 Sections)

202
playspots

133
slalom courses

Recherche avancée
Supprimer les filtres
(default) 4045 queries took 1692 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.topo_type_id = 1 order by nom collate utf8_unicode_ci asc9729729
2select T.topo_type_id from topos T where T.id=2151111
3select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2151 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0111
4select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2151)111
5select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=185 and CA.coordonnee_administrative_type_id=CAT.id110
6select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=31 and CA.coordonnee_administrative_type_id=CAT.id110
7select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=1 and CA.coordonnee_administrative_type_id=CAT.id110
8select T.topo_type_id from topos T where T.id=2293110
9select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2293 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
10select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2293)111
11select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=94 and CA.coordonnee_administrative_type_id=CAT.id110
12select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=262 and CA.coordonnee_administrative_type_id=CAT.id110
13select T.topo_type_id from topos T where T.id=2677110
14select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2677 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
15select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2677)111
16select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=7 and CA.coordonnee_administrative_type_id=CAT.id110
17select T.topo_type_id from topos T where T.id=371110
18select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=371 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
19select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 371)111
20select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=115 and CA.coordonnee_administrative_type_id=CAT.id110
21select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=267 and CA.coordonnee_administrative_type_id=CAT.id110
22select T.topo_type_id from topos T where T.id=61110
23select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=61 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
24select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 61)111
25select T.topo_type_id from topos T where T.id=2274110
26select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2274 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
27select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2274)111
28select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=140 and CA.coordonnee_administrative_type_id=CAT.id110
29select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=28 and CA.coordonnee_administrative_type_id=CAT.id110
30select T.topo_type_id from topos T where T.id=2705110
31select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2705 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
32select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2705)111
33select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=221 and CA.coordonnee_administrative_type_id=CAT.id110
34select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=211 and CA.coordonnee_administrative_type_id=CAT.id110
35select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=3 and CA.coordonnee_administrative_type_id=CAT.id110
36select T.topo_type_id from topos T where T.id=340110
37select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=340 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
38select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 340)111
39select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=106 and CA.coordonnee_administrative_type_id=CAT.id110
40select T.topo_type_id from topos T where T.id=79110
41select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=79 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
42select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 79)111
43select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=110 and CA.coordonnee_administrative_type_id=CAT.id110
44select T.topo_type_id from topos T where T.id=286110
45select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=286 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
46select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 286)111
47select T.topo_type_id from topos T where T.id=300110
48select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=300 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
49select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 300)111
50select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=158 and CA.coordonnee_administrative_type_id=CAT.id110
51select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=261 and CA.coordonnee_administrative_type_id=CAT.id110
52select T.topo_type_id from topos T where T.id=509110
53select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=509 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
54select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 509)111
55select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=100 and CA.coordonnee_administrative_type_id=CAT.id110
56select T.topo_type_id from topos T where T.id=143110
57select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=143 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
58select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 143)111
59select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=126 and CA.coordonnee_administrative_type_id=CAT.id110
60select T.topo_type_id from topos T where T.id=2516110
61select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2516 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
62select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2516)111
63select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=230 and CA.coordonnee_administrative_type_id=CAT.id110
64select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=227 and CA.coordonnee_administrative_type_id=CAT.id110
65select T.topo_type_id from topos T where T.id=1899110
66select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1899 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
67select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1899)111
68select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=49 and CA.coordonnee_administrative_type_id=CAT.id110
69select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=2 and CA.coordonnee_administrative_type_id=CAT.id110
70select T.topo_type_id from topos T where T.id=2147110
71select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2147 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
72select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2147)111
73select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=98 and CA.coordonnee_administrative_type_id=CAT.id110
74select T.topo_type_id from topos T where T.id=1668110
75select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1668 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
76select T.topo_type_id from topos T where T.id=195110
77select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=195 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
78select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 195)111
79select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=114 and CA.coordonnee_administrative_type_id=CAT.id110
80select T.topo_type_id from topos T where T.id=1736110
81select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1736 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
82select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1736)111
83select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=103 and CA.coordonnee_administrative_type_id=CAT.id110
84select T.topo_type_id from topos T where T.id=482110
85select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=482 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
86select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 482)111
87select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=157 and CA.coordonnee_administrative_type_id=CAT.id110
88select T.topo_type_id from topos T where T.id=483110
89select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=483 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
90select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 483)111
91select T.topo_type_id from topos T where T.id=2175110
92select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2175 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
93select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2175)111
94select T.topo_type_id from topos T where T.id=122110
95select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=122 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
96select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 122)111
97select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=127 and CA.coordonnee_administrative_type_id=CAT.id110
98select T.topo_type_id from topos T where T.id=2369110
99select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2369 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
100select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2369)111
101select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=259 and CA.coordonnee_administrative_type_id=CAT.id110
102select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=5 and CA.coordonnee_administrative_type_id=CAT.id110
103select T.topo_type_id from topos T where T.id=2628110
104select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2628 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
105select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2628)111
106select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=109 and CA.coordonnee_administrative_type_id=CAT.id110
107select T.topo_type_id from topos T where T.id=2666110
108select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2666 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
109select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2666)111
110select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=222 and CA.coordonnee_administrative_type_id=CAT.id110
111select T.topo_type_id from topos T where T.id=137110
112select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=137 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
113select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 137)111
114select T.topo_type_id from topos T where T.id=201110
115select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=201 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
116select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 201)111
117select T.topo_type_id from topos T where T.id=55110
118select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=55 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
119select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 55)111
120select T.topo_type_id from topos T where T.id=213110
121select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=213 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
122select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 213)111
123select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=108 and CA.coordonnee_administrative_type_id=CAT.id110
124select T.topo_type_id from topos T where T.id=2180110
125select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2180 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
126select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2180)111
127select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=242 and CA.coordonnee_administrative_type_id=CAT.id110
128select T.topo_type_id from topos T where T.id=2724110
129select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2724 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
130select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2724)221
131select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=125 and CA.coordonnee_administrative_type_id=CAT.id110
132select T.topo_type_id from topos T where T.id=1658110
133select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1658 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
134select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1658)111
135select T.topo_type_id from topos T where T.id=1619110
136select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1619 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
137select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1619)111
138select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=96 and CA.coordonnee_administrative_type_id=CAT.id110
139select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=26 and CA.coordonnee_administrative_type_id=CAT.id110
140select T.topo_type_id from topos T where T.id=1731110
141select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1731 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
142select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1731)111
143select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=147 and CA.coordonnee_administrative_type_id=CAT.id110
144select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=263 and CA.coordonnee_administrative_type_id=CAT.id110
145select T.topo_type_id from topos T where T.id=228110
146select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=228 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
147select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 228)111
148select T.topo_type_id from topos T where T.id=2686110
149select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2686 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
150select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2686)111
151select T.topo_type_id from topos T where T.id=256110
152select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=256 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0111
153select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 256)111
154select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=56 and CA.coordonnee_administrative_type_id=CAT.id110
155select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=14 and CA.coordonnee_administrative_type_id=CAT.id110
156select T.topo_type_id from topos T where T.id=141110
157select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=141 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0111
158select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 141)111
159select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=59 and CA.coordonnee_administrative_type_id=CAT.id110
160select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=4 and CA.coordonnee_administrative_type_id=CAT.id111
161select T.topo_type_id from topos T where T.id=112110
162select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=112 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
163select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 112)111
164select T.topo_type_id from topos T where T.id=1601110
165select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1601 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
166select T.topo_type_id from topos T where T.id=2859110
167select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2859 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0111
168select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2859)111
169select T.topo_type_id from topos T where T.id=30110
170select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=30 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0111
171select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 30)111
172select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=92 and CA.coordonnee_administrative_type_id=CAT.id110
173select T.topo_type_id from topos T where T.id=2676110
174select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2676 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
175select T.topo_type_id from topos T where T.id=84110
176select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=84 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0111
177select T.topo_type_id from topos T where T.id=152110
178select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=152 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
179select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 152)111
180select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=91 and CA.coordonnee_administrative_type_id=CAT.id110
181select T.topo_type_id from topos T where T.id=370111
182select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=370 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0111
183select T.topo_type_id from topos T where T.id=282110
184select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=282 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
185select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 282)111
186select T.topo_type_id from topos T where T.id=182110
187select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=182 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
188select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 182)111
189select T.topo_type_id from topos T where T.id=2322110
190select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2322 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
191select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2322)111
192select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=57 and CA.coordonnee_administrative_type_id=CAT.id110
193select T.topo_type_id from topos T where T.id=384110
194select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=384 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
195select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 384)111
196select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=183 and CA.coordonnee_administrative_type_id=CAT.id110
197select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=42 and CA.coordonnee_administrative_type_id=CAT.id110
198select T.topo_type_id from topos T where T.id=2826110
199select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2826 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0110
200select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2826)111
Page rendered in 6518ms.