Eauxvives.org

Au fil de l'eau

Le Guide des Rivières

Ressources

L'Isorno

Suisse >> Suisse Sud

EDITER < >

Auteur : paddler
> créé le 12-05-2014
> révisé le 12-05-2014

Lien permanent vers l'onglet 'Description' du topo (faire clic droit/copier le lien).

Contribuez !

Situation géographique

L'Isorno est une rivière qui coule dans le canton du Tessin au sud de la Suisse. Les sommets au sud et à l'ouest de la vallée forment la frontière entre la Suisse et l'Italie.

Présentation

Le Val Onsernone est une vallée très étroite. La rivière coule dans une gorge étroite et est difficile d'accès. Il n'y a aucun pont routier, tout embarquement ou débarquement se fera au prix d'une longue marche à pied.
L'Isorno prend sa source sur les pentes Est du PizzoMedaro (2550m. d'alt.) et se jette dans la Melezza en rive gauche à Intragna.

Alimentation

Pluvio-nivale.

Période favorable

En fin de printemps (Mai-juin) pour profiter de la fonte des neige. En été et automne suite à une période pluvieuse.
Vu le caractère engorgé de la vallée il vaux mieux se méfier des jours de crues.

Débit

env. 5m3/s est un bon niveau d'eau.

Webs utiles

www.kayaktrip.fr

Alternatives de navigation

Alternatives basses eaux : Cannobino
Alternatives moyennes eaux : Melezza, Verzasca
Alternatives hautes eaux : Ribo, Melezza, Verzasca.

Auteur : paddler
> créé le 12-05-2014
> révisé le 12-05-2014

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

Contribuez !

Nom

Haut

Difficulté

IV(5) E3

Longueur

3 km

	Spruga
	Comologno

Physionomie

Très engorgé mais tout les rapides peuvent être repérés et portés, une passerelle permet de sortir à mi-parcours et rejoindre Spruga par un sentier.

Logistique

L'embarquement se fait a un pont submersible qui mène au sources d'eau chaude "Bagni di Craveggia", accessible en 3omn à pied depuis le village de Spuga par une route bitumée mais interdite à la circulation.
Le débarquement se fait à la troisième passerelle en remontant à pied pendant 30mn par un chemin raide qui mène au village de Comologno.

Paysage

Sauvage, peu de trace d'humanité.

Isolement

Autant qu'on peu l'être en europe.

Au fil de l'eau

Le premier rapide est une superbe glissière qui vous fera oublier les souffrances du portage !
Ensuite il y a un rapide qui fini en rouleau entre 2 falaises. A repérer.
Après d'autres beau rapide un seuil d'env. 3m est difficile à sécuriser.
Le débarquement se fait à un pont en bois en forme d'accent circonflexe. S’arrêter en amont pour pouvoir rejoindre le chemin.
Je n'ai jamais continué plus loin mais j'ai discuté avec des kayakistes qui ont essayés. Ils me l'ont déconseillé à cause du nombre d'infrans aux portages scabreux.

Dernière descente

Avril 2014

Les commentaires des utilisateurs concernant cette description :

On a bien essayé de remonter en voiture le 03/05 mais on s'est fait jeter par un tessinois du coup on a rebrousser chemin bien dommage ça à l'air de toute beauté..

Tristan74, le 13-05-2014 (révisé le 13-05-2014)

Voir tous les commentaires

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

12-05-2014

paddler

Dernier rapide avant le pont de débarquement.

12-05-2014

paddler

Portage pour atteindre l'embarquement.

12-05-2014

paddler

1er rapide : ça glisse !

12-05-2014

paddler

Rapide étroit

12-05-2014

paddler

Paysage...

12-05-2014

paddler

Seuil difficile à sécuriser.

Parcours	Distance	Difficulté	Nom
P1	3 km	IV(5) E3	Haut

(default) 74 queries took 70 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	1
6	SHOW FULL COLUMNS FROM `topo_bassin_details`	21	21	1
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	2
9	SHOW FULL COLUMNS FROM `topo_parcours`	4	4	1
10	SHOW FULL COLUMNS FROM `topo_parcours_details`	25	25	1
11	SHOW FULL COLUMNS FROM `topo_rivieres`	2	2	1
12	SHOW FULL COLUMNS FROM `topo_riviere_details`	35	35	2
13	SHOW FULL COLUMNS FROM `topo_spots`	2	2	1
14	SHOW FULL COLUMNS FROM `topo_spot_details`	20	20	1
15	SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`	11	11	1
16	SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`	10	10	1
17	SHOW FULL COLUMNS FROM `niveau_source_donnees`	6	6	1
18	SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`	12	12	1
19	SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`	2	2	1
20	SHOW FULL COLUMNS FROM `niveaux`	12	12	1
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	1
24	SHOW FULL COLUMNS FROM `coordonnee_administrative_types`	2	2	1
25	SHOW FULL COLUMNS FROM `attachments`	19	19	1
26	SHOW FULL COLUMNS FROM `attachments_links`	6	6	1
27	SHOW FULL COLUMNS FROM `dernieres_descentes`	7	7	1
28	SHOW FULL COLUMNS FROM `topo_commentaires`	6	6	1
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	1
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 = 'isorno' 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=2385	1	1	0
43	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2385)	1	1	1
44	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=204 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=8 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
46	select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=2385 and TP.topo_id=T.id order by TP.numero_ordre	1	1	1
47	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2386)	1	1	1
48	select T.id,T.topo_type_id from topos T where T.parent_id=2385 and T.topo_type_id=1	0	0	0
49	select T.parent_id from topos T where T.id=2385	1	1	0
50	select A.*,U.username from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=2385 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	2
51	select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=2385 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id	1	1	1
52	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=80	1	1	0
53	select C.* from topo_commentaires C where C.topo_id=2385 order by C.created desc	0	0	0
54	select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2386 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id	1	1	0
55	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=2386 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id	1	1	1
56	select C.* from topo_commentaires C where C.topo_id=2386 order by C.created desc	1	1	0
57	select A.*,U.username from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2386 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc	6	6	2
58	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
59	select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (2385,2386) and N.niveau_evaluation_id=NE.id order by quand desc	0	0	1
60	select T.topo_type_id from topos T where T.id=2385	1	1	0
61	select D.* from dernieres_descentes D where D.topo_id in (2386) order by D.quand desc	0	0	1
62	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=2385 or (T.topo_type_id=4 and T.parent_id=2385)) 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
63	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 < 'Isorno' 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	5
64	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 > 'Isorno' 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	5
65	select id,nom,slug,topo_type_id from topos where id=1976	1	1	1
66	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1976)	1	1	1
67	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=137 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
68	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
69	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
70	select id,nom,slug,topo_type_id from topos where id=263	1	1	0
71	select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 263)	1	1	1
72	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=65 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
73	select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=17 and CA.coordonnee_administrative_type_id=CAT.id	1	1	0
74	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=15123	1	1	0

(default) 74 queries took 70 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 = 'isorno' and T.topo_type_id=1

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

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

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=204 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=8 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=2385 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 = 2386)

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

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

select A.*,U.username from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=2385 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=2385 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=80

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

select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2386 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=2386 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id

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

select A.*,U.username from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2386 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 (2385,2386) and N.niveau_evaluation_id=NE.id order by quand desc

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

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

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=2385 or (T.topo_type_id=4 and T.parent_id=2385)) 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 < 'Isorno' 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 > 'Isorno' 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=1976

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

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=137 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=28 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 id,nom,slug,topo_type_id from topos where id=263

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

select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=65 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=17 and CA.coordonnee_administrative_type_id=CAT.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=15123