Eauxvives.org

Au fil de l'eau

Le Guide des Rivières

Ressources

Le Sandron

France >> Rhône-Alpes >> Ardèche (07)

EDITER

Notice (8): Undefined offset: 0 [APP/app_controller.php, line 35]Code    function startupProcess() {
        $this->Component->initialize($this);
        $this->beforeFilter();
AppController::beforeFilter() - APP/app_controller.php, line 35
Controller::startupProcess() - CORE/cake/libs/controller/controller.php, line 522
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 187
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
Object::requestAction() - CORE/cake/libs/object.php, line 95
include - APP/views/rivieres/voir.ctp, line 140
View::_render() - CORE/cake/libs/view/view.php, line 736
View::render() - CORE/cake/libs/view/view.php, line 431
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - CORE/wwwroot/index.php, line 97

Notice (8): Undefined offset: 0 [APP/app_controller.php, line 38]Code    function startupProcess() {
        $this->Component->initialize($this);
        $this->beforeFilter();
AppController::beforeFilter() - APP/app_controller.php, line 38
Controller::startupProcess() - CORE/cake/libs/controller/controller.php, line 522
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 187
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
Object::requestAction() - CORE/cake/libs/object.php, line 95
include - APP/views/rivieres/voir.ctp, line 140
View::_render() - CORE/cake/libs/view/view.php, line 736
View::render() - CORE/cake/libs/view/view.php, line 431
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - CORE/wwwroot/index.php, line 97

Notice (8): Undefined offset: 0 [APP/app_controller.php, line 41]Code    function startupProcess() {
        $this->Component->initialize($this);
        $this->beforeFilter();
AppController::beforeFilter() - APP/app_controller.php, line 41
Controller::startupProcess() - CORE/cake/libs/controller/controller.php, line 522
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 187
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
Object::requestAction() - CORE/cake/libs/object.php, line 95
include - APP/views/rivieres/voir.ctp, line 140
View::_render() - CORE/cake/libs/view/view.php, line 736
View::render() - CORE/cake/libs/view/view.php, line 431
Controller::render() - CORE/cake/libs/controller/controller.php, line 909
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - CORE/wwwroot/index.php, line 97

< >

Auteur : Yelsub
> créé le 27-11-2002
> révisé le -

Lien permanent vers l'onglet de ce parcours (faire clic droit/copier le lien).

Contribuez !

Nom

Haut Sandron

Difficulté

IV+ (5), E2-E3

Longueur

4 km

	Sandron
	Pont D257 sous ST ANDEOLS de Vals

Physionomie

Parcours manoeuvrier pour bateaux assez courts et volume de moins de 3m.
De jolis seuils qu'il faut bien assurer. Portages possibles. Quelques très beaux enchainés.

Pente

Logistique

Débarquement:
A la sortie Nord de Vals, prendre à D la D257 vers ST ANDEOLS, par le col de Vals. Montée et descente sinueuse et environ 7km plus loin, vous traversez le pont de l'arrivée.

Embarquement : continuez la route en RG pour traverser ST ANDEOLS, puis redescendre au Sandron par la D218. Vous passez en RD du Sandron et pouvez vous garer peu après au niveau de maisons. Traverser à travers champs pour embarquer.

Paysage

Très beau et sauvage.

Isolement

Important, la vallée est relativement profonde.

Durée

3h voire plus si on ne connait pas.

Au fil de l'eau

Après le pont de l'arrivée, on peut continuer encore sur 300m et finir par un très bel enchainé (5). Remontée aisée en RG.

Dernière descente

nov 2002

Cliquer sur la photo pour voir le diaporama,
ou sur cette icone pour voir la photo originale
(s'ouvre dans une nouvelle fenêtre).

24-06-2003

Yelsub

avec le Gégé encore en action !

24-06-2003

Yelsub

2 photos pour le rapide après (!) le pont d'arrivée

24-06-2003

Yelsub

Le passage peut facilement se porter RG

24-06-2003

Yelsub

Un autre gros passage qui nécessite une bonne sécu (en bateau, serrer la RG dès l'entrée...)

24-06-2003

Yelsub

Très joli passage dans une belle gorge...

24-06-2003

Yelsub

Désolé : le scanner a quelques difficultés sur les diapos sombres...

Parcours	Distance	Difficulté	Nom
P1	4 km	IV+ (5), E2-E3	Haut Sandron

(default) 73 queries took 83 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `topos`	10	10	1
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';	1	1	1
3	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
4	SHOW FULL COLUMNS FROM `topo_types`	2	2	1
5	SHOW FULL COLUMNS FROM `topo_bassins`	2	2	2
6	SHOW FULL COLUMNS FROM `topo_bassin_details`	21	21	2
7	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
8	SHOW FULL COLUMNS FROM `phpbb_users`	76	76	3
9	SHOW FULL COLUMNS FROM `topo_parcours`	4	4	2
10	SHOW FULL COLUMNS FROM `topo_parcours_details`	25	25	2
11	SHOW FULL COLUMNS FROM `topo_rivieres`	2	2	2
12	SHOW FULL COLUMNS FROM `topo_riviere_details`	35	35	2
13	SHOW FULL COLUMNS FROM `topo_spots`	2	2	2
14	SHOW FULL COLUMNS FROM `topo_spot_details`	20	20	2
15	SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`	11	11	2
16	SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`	10	10	2
17	SHOW FULL COLUMNS FROM `niveau_source_donnees`	6	6	2
18	SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`	12	12	2
19	SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`	2	2	2
20	SHOW FULL COLUMNS FROM `niveaux`	12	12	2
21	SHOW FULL COLUMNS FROM `niveau_evaluations`	3	3	1
22	SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`	3	3	1
23	SHOW FULL COLUMNS FROM `coordonnees_administratives`	9	9	2
24	SHOW FULL COLUMNS FROM `coordonnee_administrative_types`	2	2	1
25	SHOW FULL COLUMNS FROM `attachments`	19	19	2
26	SHOW FULL COLUMNS FROM `attachments_links`	6	6	1
27	SHOW FULL COLUMNS FROM `dernieres_descentes`	7	7	2
28	SHOW FULL COLUMNS FROM `topo_commentaires`	6	6	2
29	SHOW FULL COLUMNS FROM `aide_edition_topos`	7	7	1
30	SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`	12	12	1
31	SHOW FULL COLUMNS FROM `clubs_ffck`	15	15	2
32	SHOW FULL COLUMNS FROM `petite_annonces`	12	12	1
33	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';	1	1	1
34	SHOW FULL COLUMNS FROM `petite_annonce_types`	5	5	1
35	SHOW FULL COLUMNS FROM `petite_annonce_categories`	2	2	1
36	SHOW FULL COLUMNS FROM `petite_annonce_matos_types`	3	3	1
37	SHOW FULL COLUMNS FROM `petite_annonce_commentaires`	6	6	1
38	SHOW FULL COLUMNS FROM `petite_annonce_disciplines`	3	3	1
39	SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`	3	3	1
40	SHOW FULL COLUMNS FROM `niveau_alertes`	5	5	1
41	select T.id from topos T where T.slug = 'sandron' and T.topo_type_id=1	1	1	3
42	select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.id=124	1	1	0
43	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 124)	1	1	0
44	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
45	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=43 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
46	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
47	select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=124 and TP.topo_id=T.id order by TP.numero_ordre	1	1	0
48	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1010)	1	1	1
49	select T.id,T.topo_type_id from topos T where T.parent_id=124 and T.topo_type_id=1	0	0	0
50	select T.parent_id from topos T where T.id=124	1	1	0
51	select A.*,U.username from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=124 and T.topo_type_id=4 and AL.foreign_id=T.id and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc	6	6	1
52	select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=124 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id	1	1	1
53	select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=60	1	1	0
54	select C.* from topo_commentaires C where C.topo_id=124 order by C.created desc	0	0	0
55	select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1010 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id	1	1	0
56	select T.id,T.slug,T.topo_type_id,TP.numero_ordre,TPD.* from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1010 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id	1	1	1
57	select C.* from topo_commentaires C where C.topo_id=1010 order by C.created desc	0	0	0
58	select A.*,U.username from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1010 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc	6	6	1
59	select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=1	1	1	0
60	select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (124,1010) and N.niveau_evaluation_id=NE.id order by quand desc	0	0	1
61	select T.topo_type_id from topos T where T.id=124	1	1	0
62	select D.* from dernieres_descentes D where D.topo_id in (1010) order by D.quand desc	1	1	1
63	select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=832	1	1	0
64	select TP.numero_ordre from topos T,topo_parcours TP where T.id=1010 and TP.topo_id=T.id	1	1	0
65	select distinct SM.id,SM.nom,SM.web_adress1,SM.web_adress2,RN.niveau_references_de_niveau_type_id from topos T,niveau_stations_de_mesures SM,niveau_references_de_niveaux RN where (T.id=124 or (T.topo_type_id=4 and T.parent_id=124)) and RN.topo_id=T.id and RN.niveau_stations_de_mesure_id=SM.id and RN.publiable=1 and (SM.actif is null or SM.actif=1) order by SM.nom asc	0	0	1
66	select T.id,T.slug,T.nom from topos T left join topo_rivieres TR on TR.topo_id = T.id left join topo_riviere_details TRD on TRD.topo_riviere_id = TR.id left join topo_parcours TP on TP.topo_id = T.id left join topo_parcours_details TPD on TPD.topo_parcours_id = TP.id left join topo_spots TS on TS.topo_id = T.id left join topo_spot_details TSD on TSD.topo_spot_id = TS.id left join topo_bassins TB on TB.topo_id = T.id left join topo_bassin_details TBD on TBD.topo_bassin_id = TB.id where T.slug < 'sandron' and T.topo_type_id = 1 and case T.topo_type_id when 1 then TRD.etat when 4 then TPD.etat when 2 then TSD.etat when 3 then TBD.etat else null end = 0 order by T.slug desc limit 1	1	1	7
67	select T.id,T.slug,T.nom from topos T left join topo_rivieres TR on TR.topo_id = T.id left join topo_riviere_details TRD on TRD.topo_riviere_id = TR.id left join topo_parcours TP on TP.topo_id = T.id left join topo_parcours_details TPD on TPD.topo_parcours_id = TP.id left join topo_spots TS on TS.topo_id = T.id left join topo_spot_details TSD on TSD.topo_spot_id = TS.id left join topo_bassins TB on TB.topo_id = T.id left join topo_bassin_details TBD on TBD.topo_bassin_id = TB.id where T.slug > 'sandron' and T.topo_type_id = 1 and case T.topo_type_id when 1 then TRD.etat when 4 then TPD.etat when 2 then TSD.etat when 3 then TBD.etat else null end = 0 order by T.slug asc limit 1	1	1	4
68	select id,nom,slug,topo_type_id from topos where id=2398	1	1	0
69	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2398)	1	1	0
70	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=50 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
71	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=12 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
72	select id,nom,slug,topo_type_id from topos where id=212	1	1	0
73	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 212)	1	1	0

(default) 73 queries took 83 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `topos`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';

SHOW FULL COLUMNS FROM `topo_types`

SHOW FULL COLUMNS FROM `topo_bassins`

SHOW FULL COLUMNS FROM `topo_bassin_details`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';

SHOW FULL COLUMNS FROM `phpbb_users`

SHOW FULL COLUMNS FROM `topo_parcours`

SHOW FULL COLUMNS FROM `topo_parcours_details`

SHOW FULL COLUMNS FROM `topo_rivieres`

SHOW FULL COLUMNS FROM `topo_riviere_details`

SHOW FULL COLUMNS FROM `topo_spots`

SHOW FULL COLUMNS FROM `topo_spot_details`

SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`

SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`

SHOW FULL COLUMNS FROM `niveau_source_donnees`

SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`

SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`

SHOW FULL COLUMNS FROM `niveaux`

SHOW FULL COLUMNS FROM `niveau_evaluations`

SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`

SHOW FULL COLUMNS FROM `coordonnees_administratives`

SHOW FULL COLUMNS FROM `coordonnee_administrative_types`

SHOW FULL COLUMNS FROM `attachments`

SHOW FULL COLUMNS FROM `attachments_links`

SHOW FULL COLUMNS FROM `dernieres_descentes`

SHOW FULL COLUMNS FROM `topo_commentaires`

SHOW FULL COLUMNS FROM `aide_edition_topos`

SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`

SHOW FULL COLUMNS FROM `clubs_ffck`

SHOW FULL COLUMNS FROM `petite_annonces`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';

SHOW FULL COLUMNS FROM `petite_annonce_types`

SHOW FULL COLUMNS FROM `petite_annonce_categories`

SHOW FULL COLUMNS FROM `petite_annonce_matos_types`

SHOW FULL COLUMNS FROM `petite_annonce_commentaires`

SHOW FULL COLUMNS FROM `petite_annonce_disciplines`

SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`

SHOW FULL COLUMNS FROM `niveau_alertes`

select T.id from topos T where T.slug = 'sandron' and T.topo_type_id=1

select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.id=124

select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 124)

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

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=43 and CA.coordonnee_administrative_type_id=CAT.id

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

select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=124 and TP.topo_id=T.id order by TP.numero_ordre

select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1010)

select T.id,T.topo_type_id from topos T where T.parent_id=124 and T.topo_type_id=1

select T.parent_id from topos T where T.id=124

select A.*,U.username from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=124 and T.topo_type_id=4 and AL.foreign_id=T.id and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc

select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=124 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id

select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=60

select C.* from topo_commentaires C where C.topo_id=124 order by C.created desc

select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1010 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id

select T.id,T.slug,T.topo_type_id,TP.numero_ordre,TPD.* from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1010 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id

select C.* from topo_commentaires C where C.topo_id=1010 order by C.created desc

select A.*,U.username from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1010 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc

select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=1

select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (124,1010) and N.niveau_evaluation_id=NE.id order by quand desc

select T.topo_type_id from topos T where T.id=124

select D.* from dernieres_descentes D where D.topo_id in (1010) order by D.quand desc

select U.user_id,U.username,U.username_clean,P.pf_nom,P.pf_prenom from phpbb_users U left join phpbb_profile_fields_data P on U.user_id=P.user_id where U.user_id=832

select TP.numero_ordre from topos T,topo_parcours TP where T.id=1010 and TP.topo_id=T.id

select distinct SM.id,SM.nom,SM.web_adress1,SM.web_adress2,RN.niveau_references_de_niveau_type_id from topos T,niveau_stations_de_mesures SM,niveau_references_de_niveaux RN where (T.id=124 or (T.topo_type_id=4 and T.parent_id=124)) and RN.topo_id=T.id and RN.niveau_stations_de_mesure_id=SM.id and RN.publiable=1 and (SM.actif is null or SM.actif=1) order by SM.nom asc

select T.id,T.slug,T.nom from topos T left join topo_rivieres TR on TR.topo_id = T.id left join topo_riviere_details TRD on TRD.topo_riviere_id = TR.id left join topo_parcours TP on TP.topo_id = T.id left join topo_parcours_details TPD on TPD.topo_parcours_id = TP.id left join topo_spots TS on TS.topo_id = T.id left join topo_spot_details TSD on TSD.topo_spot_id = TS.id left join topo_bassins TB on TB.topo_id = T.id left join topo_bassin_details TBD on TBD.topo_bassin_id = TB.id where T.slug < 'sandron' and T.topo_type_id = 1 and case T.topo_type_id when 1 then TRD.etat when 4 then TPD.etat when 2 then TSD.etat when 3 then TBD.etat else null end = 0 order by T.slug desc limit 1

select T.id,T.slug,T.nom from topos T left join topo_rivieres TR on TR.topo_id = T.id left join topo_riviere_details TRD on TRD.topo_riviere_id = TR.id left join topo_parcours TP on TP.topo_id = T.id left join topo_parcours_details TPD on TPD.topo_parcours_id = TP.id left join topo_spots TS on TS.topo_id = T.id left join topo_spot_details TSD on TSD.topo_spot_id = TS.id left join topo_bassins TB on TB.topo_id = T.id left join topo_bassin_details TBD on TBD.topo_bassin_id = TB.id where T.slug > 'sandron' and T.topo_type_id = 1 and case T.topo_type_id when 1 then TRD.etat when 4 then TPD.etat when 2 then TSD.etat when 3 then TBD.etat else null end = 0 order by T.slug asc limit 1

select id,nom,slug,topo_type_id from topos where id=2398

select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2398)

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=50 and CA.coordonnee_administrative_type_id=CAT.id

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=12 and CA.coordonnee_administrative_type_id=CAT.id

select id,nom,slug,topo_type_id from topos where id=212

select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 212)