| 1 | select 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 asc | | 972 | 972 | 10 |
| 2 | select T.topo_type_id from topos T where T.id=2151 | | 1 | 1 | 1 |
| 3 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2151 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 4 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2151) | | 1 | 1 | 1 |
| 5 | select 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.id | | 1 | 1 | 0 |
| 6 | select 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.id | | 1 | 1 | 0 |
| 7 | select 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.id | | 1 | 1 | 0 |
| 8 | select T.topo_type_id from topos T where T.id=2293 | | 1 | 1 | 0 |
| 9 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2293 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 10 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2293) | | 1 | 1 | 1 |
| 11 | select 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.id | | 1 | 1 | 0 |
| 12 | select 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.id | | 1 | 1 | 0 |
| 13 | select T.topo_type_id from topos T where T.id=2677 | | 1 | 1 | 0 |
| 14 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2677 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 15 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2677) | | 1 | 1 | 1 |
| 16 | select 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.id | | 1 | 1 | 0 |
| 17 | select T.topo_type_id from topos T where T.id=371 | | 1 | 1 | 0 |
| 18 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=371 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 19 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 371) | | 1 | 1 | 1 |
| 20 | select 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.id | | 1 | 1 | 0 |
| 21 | select 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.id | | 1 | 1 | 0 |
| 22 | select T.topo_type_id from topos T where T.id=61 | | 1 | 1 | 0 |
| 23 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=61 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 24 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 61) | | 1 | 1 | 1 |
| 25 | select T.topo_type_id from topos T where T.id=2274 | | 1 | 1 | 0 |
| 26 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2274 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 27 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2274) | | 1 | 1 | 1 |
| 28 | select 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.id | | 1 | 1 | 0 |
| 29 | select 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.id | | 1 | 1 | 0 |
| 30 | select T.topo_type_id from topos T where T.id=2705 | | 1 | 1 | 0 |
| 31 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2705 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 32 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2705) | | 1 | 1 | 1 |
| 33 | select 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.id | | 1 | 1 | 0 |
| 34 | select 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.id | | 1 | 1 | 0 |
| 35 | select 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.id | | 1 | 1 | 0 |
| 36 | select T.topo_type_id from topos T where T.id=340 | | 1 | 1 | 0 |
| 37 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=340 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 38 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 340) | | 1 | 1 | 1 |
| 39 | select 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.id | | 1 | 1 | 0 |
| 40 | select T.topo_type_id from topos T where T.id=79 | | 1 | 1 | 0 |
| 41 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=79 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 42 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 79) | | 1 | 1 | 1 |
| 43 | select 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.id | | 1 | 1 | 0 |
| 44 | select T.topo_type_id from topos T where T.id=286 | | 1 | 1 | 0 |
| 45 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=286 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 46 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 286) | | 1 | 1 | 1 |
| 47 | select T.topo_type_id from topos T where T.id=300 | | 1 | 1 | 0 |
| 48 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=300 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 49 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 300) | | 1 | 1 | 1 |
| 50 | select 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.id | | 1 | 1 | 0 |
| 51 | select 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.id | | 1 | 1 | 0 |
| 52 | select T.topo_type_id from topos T where T.id=509 | | 1 | 1 | 0 |
| 53 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=509 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 54 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 509) | | 1 | 1 | 1 |
| 55 | select 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.id | | 1 | 1 | 0 |
| 56 | select T.topo_type_id from topos T where T.id=143 | | 1 | 1 | 0 |
| 57 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=143 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 58 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 143) | | 1 | 1 | 1 |
| 59 | select 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.id | | 1 | 1 | 0 |
| 60 | select T.topo_type_id from topos T where T.id=2516 | | 1 | 1 | 0 |
| 61 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2516 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 62 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2516) | | 1 | 1 | 1 |
| 63 | select 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.id | | 1 | 1 | 0 |
| 64 | select 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.id | | 1 | 1 | 0 |
| 65 | select T.topo_type_id from topos T where T.id=1899 | | 1 | 1 | 0 |
| 66 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1899 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 67 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1899) | | 1 | 1 | 1 |
| 68 | select 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.id | | 1 | 1 | 0 |
| 69 | select 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.id | | 1 | 1 | 0 |
| 70 | select T.topo_type_id from topos T where T.id=2147 | | 1 | 1 | 0 |
| 71 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2147 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 72 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2147) | | 1 | 1 | 1 |
| 73 | select 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.id | | 1 | 1 | 0 |
| 74 | select T.topo_type_id from topos T where T.id=1668 | | 1 | 1 | 0 |
| 75 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1668 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 76 | select T.topo_type_id from topos T where T.id=195 | | 1 | 1 | 0 |
| 77 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=195 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 78 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 195) | | 1 | 1 | 1 |
| 79 | select 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.id | | 1 | 1 | 0 |
| 80 | select T.topo_type_id from topos T where T.id=1736 | | 1 | 1 | 0 |
| 81 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1736 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 82 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1736) | | 1 | 1 | 1 |
| 83 | select 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.id | | 1 | 1 | 0 |
| 84 | select T.topo_type_id from topos T where T.id=482 | | 1 | 1 | 0 |
| 85 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=482 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 86 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 482) | | 1 | 1 | 1 |
| 87 | select 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.id | | 1 | 1 | 0 |
| 88 | select T.topo_type_id from topos T where T.id=483 | | 1 | 1 | 0 |
| 89 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=483 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 90 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 483) | | 1 | 1 | 1 |
| 91 | select T.topo_type_id from topos T where T.id=2175 | | 1 | 1 | 0 |
| 92 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2175 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 93 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2175) | | 1 | 1 | 1 |
| 94 | select T.topo_type_id from topos T where T.id=122 | | 1 | 1 | 0 |
| 95 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=122 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 96 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 122) | | 1 | 1 | 1 |
| 97 | select 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.id | | 1 | 1 | 1 |
| 98 | select T.topo_type_id from topos T where T.id=2369 | | 1 | 1 | 0 |
| 99 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2369 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 100 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2369) | | 1 | 1 | 1 |
| 101 | select 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.id | | 1 | 1 | 0 |
| 102 | select 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.id | | 1 | 1 | 0 |
| 103 | select T.topo_type_id from topos T where T.id=2628 | | 1 | 1 | 0 |
| 104 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2628 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 105 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2628) | | 1 | 1 | 1 |
| 106 | select 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.id | | 1 | 1 | 0 |
| 107 | select T.topo_type_id from topos T where T.id=2666 | | 1 | 1 | 0 |
| 108 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2666 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 109 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2666) | | 1 | 1 | 1 |
| 110 | select 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.id | | 1 | 1 | 0 |
| 111 | select T.topo_type_id from topos T where T.id=137 | | 1 | 1 | 0 |
| 112 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=137 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 113 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 137) | | 1 | 1 | 1 |
| 114 | select T.topo_type_id from topos T where T.id=201 | | 1 | 1 | 0 |
| 115 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=201 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 116 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 201) | | 1 | 1 | 1 |
| 117 | select T.topo_type_id from topos T where T.id=55 | | 1 | 1 | 0 |
| 118 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=55 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 119 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 55) | | 1 | 1 | 1 |
| 120 | select T.topo_type_id from topos T where T.id=213 | | 1 | 1 | 0 |
| 121 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=213 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 122 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 213) | | 1 | 1 | 1 |
| 123 | select 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.id | | 1 | 1 | 0 |
| 124 | select T.topo_type_id from topos T where T.id=2180 | | 1 | 1 | 0 |
| 125 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2180 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 126 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2180) | | 1 | 1 | 1 |
| 127 | select 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.id | | 1 | 1 | 0 |
| 128 | select T.topo_type_id from topos T where T.id=2724 | | 1 | 1 | 0 |
| 129 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2724 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 130 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2724) | | 2 | 2 | 1 |
| 131 | select 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.id | | 1 | 1 | 0 |
| 132 | select T.topo_type_id from topos T where T.id=1658 | | 1 | 1 | 0 |
| 133 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1658 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 134 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1658) | | 1 | 1 | 1 |
| 135 | select T.topo_type_id from topos T where T.id=1619 | | 1 | 1 | 0 |
| 136 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1619 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 137 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1619) | | 1 | 1 | 1 |
| 138 | select 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.id | | 1 | 1 | 0 |
| 139 | select 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.id | | 1 | 1 | 0 |
| 140 | select T.topo_type_id from topos T where T.id=1731 | | 1 | 1 | 0 |
| 141 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1731 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 142 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1731) | | 1 | 1 | 1 |
| 143 | select 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.id | | 1 | 1 | 0 |
| 144 | select 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.id | | 1 | 1 | 0 |
| 145 | select T.topo_type_id from topos T where T.id=228 | | 1 | 1 | 0 |
| 146 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=228 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 147 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 228) | | 1 | 1 | 1 |
| 148 | select T.topo_type_id from topos T where T.id=2686 | | 1 | 1 | 0 |
| 149 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2686 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 150 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2686) | | 1 | 1 | 1 |
| 151 | select T.topo_type_id from topos T where T.id=256 | | 1 | 1 | 0 |
| 152 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=256 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 153 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 256) | | 1 | 1 | 1 |
| 154 | select 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.id | | 1 | 1 | 0 |
| 155 | select 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.id | | 1 | 1 | 0 |
| 156 | select T.topo_type_id from topos T where T.id=141 | | 1 | 1 | 0 |
| 157 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=141 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 158 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 141) | | 1 | 1 | 1 |
| 159 | select 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.id | | 1 | 1 | 1 |
| 160 | select 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.id | | 1 | 1 | 0 |
| 161 | select T.topo_type_id from topos T where T.id=112 | | 1 | 1 | 0 |
| 162 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=112 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 163 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 112) | | 1 | 1 | 1 |
| 164 | select T.topo_type_id from topos T where T.id=1601 | | 1 | 1 | 0 |
| 165 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=1601 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 166 | select T.topo_type_id from topos T where T.id=2859 | | 1 | 1 | 0 |
| 167 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2859 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 168 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2859) | | 1 | 1 | 1 |
| 169 | select T.topo_type_id from topos T where T.id=30 | | 1 | 1 | 0 |
| 170 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=30 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 171 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 30) | | 1 | 1 | 1 |
| 172 | select 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.id | | 1 | 1 | 0 |
| 173 | select T.topo_type_id from topos T where T.id=2676 | | 1 | 1 | 0 |
| 174 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2676 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 175 | select T.topo_type_id from topos T where T.id=84 | | 1 | 1 | 0 |
| 176 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=84 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 177 | select T.topo_type_id from topos T where T.id=152 | | 1 | 1 | 0 |
| 178 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=152 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 179 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 152) | | 1 | 1 | 1 |
| 180 | select 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.id | | 1 | 1 | 0 |
| 181 | select T.topo_type_id from topos T where T.id=370 | | 1 | 1 | 0 |
| 182 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=370 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 183 | select T.topo_type_id from topos T where T.id=282 | | 1 | 1 | 0 |
| 184 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=282 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 0 |
| 185 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 282) | | 1 | 1 | 1 |
| 186 | select T.topo_type_id from topos T where T.id=182 | | 1 | 1 | 0 |
| 187 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=182 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 188 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 182) | | 1 | 1 | 1 |
| 189 | select T.topo_type_id from topos T where T.id=2322 | | 1 | 1 | 0 |
| 190 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2322 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 191 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2322) | | 1 | 1 | 1 |
| 192 | select 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.id | | 1 | 1 | 0 |
| 193 | select T.topo_type_id from topos T where T.id=384 | | 1 | 1 | 0 |
| 194 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=384 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 195 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 384) | | 1 | 1 | 1 |
| 196 | select 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.id | | 1 | 1 | 0 |
| 197 | select 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.id | | 1 | 1 | 0 |
| 198 | select T.topo_type_id from topos T where T.id=2826 | | 1 | 1 | 0 |
| 199 | select count(*) from topo_rivieres TS,topo_riviere_details TSD where TS.topo_id=2826 and TSD.topo_riviere_id=TS.id and TSD.etat >= 0 | | 1 | 1 | 1 |
| 200 | select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2826) | | 1 | 1 | 1 |
