Riviere

La Gouarège

France > Occitanie > Ariège (09)
Clément By Clément | 13.12.2020

1 parcour(s) répertorié(s) sur cette rivière
P1- Classique
3 km
Cl IV E1
No level reference
DESCRIPTION
Geographic location
Affluent rive gauche du Salat, cette rivière prend sa source dans le massif de l'Estelas. Cette rivière est alimentée par un énorme réseau karstique : la grotte d'Aliou. D'ailleurs, ce site est soumis à réglementation pour la préservation du monde cavernicole. La Gouarège au cours de ces 7km de descente traverse le village de Cazavet et de Prat-Bonrepaux avant de rejoindre le Salat.
Introduction
La Gouarège offre un parcours de haute rivière court mais intense. C'est une merveille du piémont ariégeois.
Alimentation
Pluviale
Période favorable
Après de fortes précipitations
Echelle
Niveau d'eau à regarder au niveau du pont de l'embarquement.
Débit
Estimation : entre 8 et 10m3/s semble être une bonne fourchette de navigation
Sources niveaux
 
Niveau temps réél
 
Qualité de l'eau
 
Température de l'eau
 
Risques particuliers
Attention aux arbres et aux rappels
Secours
 
Prestataires
 
Clubs locaux
 
Bonnes adresses
 
Bibliographie
 
Webs utiles
 
Réglementation, accords
 
Alternatives de navigation
 
Commentaires
 
Comments
0

Warning ! Rivers lives and are subject to permanent change. Topo-Guides's authors and website creators cannot be considered as responsable in case of accident due to incorrect informations in this guide.

(default) 91 queries took 92 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `topos`10101
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
4SHOW FULL COLUMNS FROM `topo_types`221
5SHOW FULL COLUMNS FROM `topo_bassins`221
6SHOW FULL COLUMNS FROM `topo_bassin_details`21211
7SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
8SHOW FULL COLUMNS FROM `phpbb_users`68682
9SHOW FULL COLUMNS FROM `topo_parcours`441
10SHOW FULL COLUMNS FROM `topo_parcours_details`25251
11SHOW FULL COLUMNS FROM `topo_rivieres`221
12SHOW FULL COLUMNS FROM `topo_riviere_details`35352
13SHOW FULL COLUMNS FROM `topo_spots`221
14SHOW FULL COLUMNS FROM `topo_spot_details`20201
15SHOW FULL COLUMNS FROM `topo_details`881
16SHOW FULL COLUMNS FROM `topo_rubriques`11111
17SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11111
18SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`10101
19SHOW FULL COLUMNS FROM `niveau_source_donnees`771
20SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`12121
21SHOW FULL COLUMNS FROM `topos_facility`58582
22SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`24242
23SHOW FULL COLUMNS FROM `clubs_ffck`15151
24SHOW FULL COLUMNS FROM `petite_annonces`12121
25SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';111
26SHOW FULL COLUMNS FROM `petite_annonce_types`551
27SHOW FULL COLUMNS FROM `petite_annonce_categories`221
28SHOW FULL COLUMNS FROM `petite_annonce_matos_types`331
29SHOW FULL COLUMNS FROM `attachments`19191
30SHOW FULL COLUMNS FROM `attachments_links`661
31SHOW FULL COLUMNS FROM `petite_annonce_commentaires`661
32SHOW FULL COLUMNS FROM `petite_annonce_disciplines`331
33SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`331
34SHOW FULL COLUMNS FROM `niveau_alertes`551
35SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`331
36SHOW FULL COLUMNS FROM `coordonnees_administratives`991
37SHOW FULL COLUMNS FROM `coordonnee_administrative_types`221
38SHOW FULL COLUMNS FROM `coordonnees_administratives_facility`18181
39SHOW FULL COLUMNS FROM `carto_coordonnees`13131
40SHOW FULL COLUMNS FROM `carto_types`221
41SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`221
42SHOW FULL COLUMNS FROM `niveaux`12121
43SHOW FULL COLUMNS FROM `niveau_evaluations`331
44SHOW FULL COLUMNS FROM `dernieres_descentes`771
45SHOW FULL COLUMNS FROM `topo_commentaires`661
46SHOW FULL COLUMNS FROM `aide_edition_topos`771
47select T.id from topos T where T.slug = 'gouarege' and T.topo_type_id=1113
48select A.*,U.username, U.user_avatar from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=2914 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 desc221
49SELECT `TopoFacility`.`id`, `TopoFacility`.`topo_type_id`, `TopoFacility`.`nom`, `TopoFacility`.`nom2`, `TopoFacility`.`slug`, `TopoFacility`.`parent_id`, `TopoFacility`.`left`, `TopoFacility`.`right`, `TopoFacility`.`created`, `TopoFacility`.`modified`, `TopoFacility`.`riviere`, `TopoFacility`.`slugRiviere`, `TopoFacility`.`numero_ordre`, `TopoFacility`.`etat`, `TopoFacility`.`article`, `TopoFacility`.`situation_geographique`, `TopoFacility`.`presentation`, `TopoFacility`.`alimentation`, `TopoFacility`.`echelle`, `TopoFacility`.`debit`, `TopoFacility`.`qualite_eau`, `TopoFacility`.`temperature_eau`, `TopoFacility`.`source_niveaux`, `TopoFacility`.`periode_favorable`, `TopoFacility`.`risques_particuliers`, `TopoFacility`.`secours`, `TopoFacility`.`prestataires_eau_vive`, `TopoFacility`.`clubs_locaux`, `TopoFacility`.`bonnes_adresses`, `TopoFacility`.`bibliographie`, `TopoFacility`.`web_utiles`, `TopoFacility`.`commentaire`, `TopoFacility`.`img_carte`, `TopoFacility`.`url_carte`, `TopoFacility`.`reglementation_accords`, `TopoFacility`.`alternative_Basse`, `TopoFacility`.`alternative_Moyenne`, `TopoFacility`.`alternative_Haute`, `TopoFacility`.`niveau_temps_reel`, `TopoFacility`.`user_id`, `TopoFacility`.`user_2_id`, `TopoFacility`.`date_premiere_publication`, `TopoFacility`.`embarquement`, `TopoFacility`.`debarquement`, `TopoFacility`.`longueur`, `TopoFacility`.`distance`, `TopoFacility`.`pente_moyenne`, `TopoFacility`.`cotation`, `TopoFacility`.`physionomie`, `TopoFacility`.`logistique`, `TopoFacility`.`isolement`, `TopoFacility`.`paysage`, `TopoFacility`.`playboating`, `TopoFacility`.`duree`, `TopoFacility`.`guide_kilometrique`, `TopoFacility`.`date_derniere_descente`, `TopoFacility`.`caracteristiques`, `TopoFacility`.`renseignements`, `TopoType`.`id`, `TopoType`.`nom`, `TopoAlias`.`id`, `TopoAlias`.`topo_type_id`, `TopoAlias`.`nom`, `TopoAlias`.`slug`, `TopoAlias`.`parent_id`, `TopoAlias`.`left`, `TopoAlias`.`right`, `TopoAlias`.`created`, `TopoAlias`.`modified`, `TopoAlias`.`Migration_topo_id_original` FROM `topos_facility` AS `TopoFacility` LEFT JOIN `topo_types` AS `TopoType` ON (`TopoFacility`.`topo_type_id` = `TopoType`.`id`) LEFT JOIN `topos` AS `TopoAlias` ON (`TopoFacility`.`parent_id` = `TopoAlias`.`id`) WHERE `TopoFacility`.`parent_id` = 2914 ORDER BY `TopoFacility`.`numero_ordre` asc 111
50SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
51SELECT `TopoAlias`.`id`, `TopoAlias`.`topo_type_id`, `TopoAlias`.`nom`, `TopoAlias`.`slug`, `TopoAlias`.`parent_id`, `TopoAlias`.`left`, `TopoAlias`.`right`, `TopoAlias`.`created`, `TopoAlias`.`modified`, `TopoAlias`.`Migration_topo_id_original` FROM `topos` AS `TopoAlias` WHERE `TopoAlias`.`id` = 2914 110
52SELECT `NiveauReferencesDeNiveaux`.`id`, `NiveauReferencesDeNiveaux`.`niveau_stations_de_mesure_id`, `NiveauReferencesDeNiveaux`.`topo_id`, `NiveauReferencesDeNiveaux`.`niveau_references_de_niveau_type_id`, `NiveauReferencesDeNiveaux`.`min`, `NiveauReferencesDeNiveaux`.`max`, `NiveauReferencesDeNiveaux`.`publiable`, `NiveauReferencesDeNiveaux`.`user_id`, `NiveauReferencesDeNiveaux`.`commentaire`, `NiveauReferencesDeNiveaux`.`created`, `NiveauReferencesDeNiveaux`.`modified` FROM `niveau_references_de_niveaux` AS `NiveauReferencesDeNiveaux` WHERE `NiveauReferencesDeNiveaux`.`topo_id` = (2915) 000
53SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` = (2915) 110
54SELECT `CoordonneeAdministrativeFacility`.`id`, `CoordonneeAdministrativeFacility`.`nom`, `CoordonneeAdministrativeFacility`.`slug`, `CoordonneeAdministrativeFacility`.`code`, `CoordonneeAdministrativeFacility`.`coordonnee_administrative_type_id`, `CoordonneeAdministrativeFacility`.`parent_id`, `CoordonneeAdministrativeFacility`.`lft`, `CoordonneeAdministrativeFacility`.`rght`, `CoordonneeAdministrativeFacility`.`Migration`, `CoordonneeAdministrativeFacility`.`departement_id`, `CoordonneeAdministrativeFacility`.`departement_nom`, `CoordonneeAdministrativeFacility`.`departement_code`, `CoordonneeAdministrativeFacility`.`region_id`, `CoordonneeAdministrativeFacility`.`region_nom`, `CoordonneeAdministrativeFacility`.`region_code`, `CoordonneeAdministrativeFacility`.`pays_id`, `CoordonneeAdministrativeFacility`.`pays_nom`, `CoordonneeAdministrativeFacility`.`pays_code` FROM `coordonnees_administratives_facility` AS `CoordonneeAdministrativeFacility` WHERE `CoordonneeAdministrativeFacility`.`id` = 114 110
55SELECT `CartoCoordonnee`.`id`, `CartoCoordonnee`.`objet_id`, `CartoCoordonnee`.`carto_type_id`, `CartoCoordonnee`.`carto_sous_type_id`, `CartoCoordonnee`.`lat`, `CartoCoordonnee`.`lon`, `CartoCoordonnee`.`alt`, `CartoCoordonnee`.`geocodage`, `CartoCoordonnee`.`encoded_coordinates`, `CartoCoordonnee`.`encoded_zooms`, `CartoCoordonnee`.`user_id`, `CartoCoordonnee`.`modified`, `CartoCoordonnee`.`created` FROM `carto_coordonnees` AS `CartoCoordonnee` WHERE carto_type_id IN (1, 2, 3) AND `CartoCoordonnee`.`objet_id` = (2915) 221
56select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.id=2914110
57select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2914)111
58select 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
59select 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
60select 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
61select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=2914 and TP.topo_id=T.id order by TP.numero_ordre111
62select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2915)111
63select T.id,T.topo_type_id from topos T where T.parent_id=2914 and T.topo_type_id=1000
64select T.parent_id from topos T where T.id=2914110
65select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=2914 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id111
66select U.user_id,U.username,U.username_clean,U.user_avatar,U.user_avatar_width,U.user_avatar_height,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=1998110
67select C.* from topo_commentaires C where C.topo_id=2914 order by C.created desc000
68SELECT `TopoFacility`.`id`, `TopoFacility`.`topo_type_id`, `TopoFacility`.`nom`, `TopoFacility`.`nom2`, `TopoFacility`.`slug`, `TopoFacility`.`parent_id`, `TopoFacility`.`left`, `TopoFacility`.`right`, `TopoFacility`.`created`, `TopoFacility`.`modified`, `TopoFacility`.`riviere`, `TopoFacility`.`slugRiviere`, `TopoFacility`.`numero_ordre`, `TopoFacility`.`etat`, `TopoFacility`.`article`, `TopoFacility`.`situation_geographique`, `TopoFacility`.`presentation`, `TopoFacility`.`alimentation`, `TopoFacility`.`echelle`, `TopoFacility`.`debit`, `TopoFacility`.`qualite_eau`, `TopoFacility`.`temperature_eau`, `TopoFacility`.`source_niveaux`, `TopoFacility`.`periode_favorable`, `TopoFacility`.`risques_particuliers`, `TopoFacility`.`secours`, `TopoFacility`.`prestataires_eau_vive`, `TopoFacility`.`clubs_locaux`, `TopoFacility`.`bonnes_adresses`, `TopoFacility`.`bibliographie`, `TopoFacility`.`web_utiles`, `TopoFacility`.`commentaire`, `TopoFacility`.`img_carte`, `TopoFacility`.`url_carte`, `TopoFacility`.`reglementation_accords`, `TopoFacility`.`alternative_Basse`, `TopoFacility`.`alternative_Moyenne`, `TopoFacility`.`alternative_Haute`, `TopoFacility`.`niveau_temps_reel`, `TopoFacility`.`user_id`, `TopoFacility`.`user_2_id`, `TopoFacility`.`date_premiere_publication`, `TopoFacility`.`embarquement`, `TopoFacility`.`debarquement`, `TopoFacility`.`longueur`, `TopoFacility`.`distance`, `TopoFacility`.`pente_moyenne`, `TopoFacility`.`cotation`, `TopoFacility`.`physionomie`, `TopoFacility`.`logistique`, `TopoFacility`.`isolement`, `TopoFacility`.`paysage`, `TopoFacility`.`playboating`, `TopoFacility`.`duree`, `TopoFacility`.`guide_kilometrique`, `TopoFacility`.`date_derniere_descente`, `TopoFacility`.`caracteristiques`, `TopoFacility`.`renseignements`, `TopoType`.`id`, `TopoType`.`nom` FROM `topos_facility` AS `TopoFacility` LEFT JOIN `topo_types` AS `TopoType` ON (`TopoFacility`.`topo_type_id` = `TopoType`.`id`) WHERE `TopoFacility`.`id` = 2914 111
69SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 1 110
70SELECT `NiveauReferencesDeNiveaux`.`id`, `NiveauReferencesDeNiveaux`.`niveau_stations_de_mesure_id`, `NiveauReferencesDeNiveaux`.`topo_id`, `NiveauReferencesDeNiveaux`.`niveau_references_de_niveau_type_id`, `NiveauReferencesDeNiveaux`.`min`, `NiveauReferencesDeNiveaux`.`max`, `NiveauReferencesDeNiveaux`.`publiable`, `NiveauReferencesDeNiveaux`.`user_id`, `NiveauReferencesDeNiveaux`.`commentaire`, `NiveauReferencesDeNiveaux`.`created`, `NiveauReferencesDeNiveaux`.`modified` FROM `niveau_references_de_niveaux` AS `NiveauReferencesDeNiveaux` WHERE `NiveauReferencesDeNiveaux`.`topo_id` = (2914) 001
71select U.user_id,U.username,U.username_clean,U.user_avatar,U.user_avatar_width,U.user_avatar_height,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=1110
72SELECT `TopoFacility`.`id`, `TopoFacility`.`topo_type_id`, `TopoFacility`.`nom`, `TopoFacility`.`nom2`, `TopoFacility`.`slug`, `TopoFacility`.`parent_id`, `TopoFacility`.`left`, `TopoFacility`.`right`, `TopoFacility`.`created`, `TopoFacility`.`modified`, `TopoFacility`.`riviere`, `TopoFacility`.`slugRiviere`, `TopoFacility`.`numero_ordre`, `TopoFacility`.`etat`, `TopoFacility`.`article`, `TopoFacility`.`situation_geographique`, `TopoFacility`.`presentation`, `TopoFacility`.`alimentation`, `TopoFacility`.`echelle`, `TopoFacility`.`debit`, `TopoFacility`.`qualite_eau`, `TopoFacility`.`temperature_eau`, `TopoFacility`.`source_niveaux`, `TopoFacility`.`periode_favorable`, `TopoFacility`.`risques_particuliers`, `TopoFacility`.`secours`, `TopoFacility`.`prestataires_eau_vive`, `TopoFacility`.`clubs_locaux`, `TopoFacility`.`bonnes_adresses`, `TopoFacility`.`bibliographie`, `TopoFacility`.`web_utiles`, `TopoFacility`.`commentaire`, `TopoFacility`.`img_carte`, `TopoFacility`.`url_carte`, `TopoFacility`.`reglementation_accords`, `TopoFacility`.`alternative_Basse`, `TopoFacility`.`alternative_Moyenne`, `TopoFacility`.`alternative_Haute`, `TopoFacility`.`niveau_temps_reel`, `TopoFacility`.`user_id`, `TopoFacility`.`user_2_id`, `TopoFacility`.`date_premiere_publication`, `TopoFacility`.`embarquement`, `TopoFacility`.`debarquement`, `TopoFacility`.`longueur`, `TopoFacility`.`distance`, `TopoFacility`.`pente_moyenne`, `TopoFacility`.`cotation`, `TopoFacility`.`physionomie`, `TopoFacility`.`logistique`, `TopoFacility`.`isolement`, `TopoFacility`.`paysage`, `TopoFacility`.`playboating`, `TopoFacility`.`duree`, `TopoFacility`.`guide_kilometrique`, `TopoFacility`.`date_derniere_descente`, `TopoFacility`.`caracteristiques`, `TopoFacility`.`renseignements` FROM `topos_facility` AS `TopoFacility` WHERE `TopoFacility`.`id` = 2914 111
73SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (2914) 001
74select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2915 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
75select 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=2915 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
76select C.* from topo_commentaires C where C.topo_id=2915 order by C.created desc000
77select D.* from dernieres_descentes D where D.topo_id=2915 order by D.quand desc002
78select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2915 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc221
79select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (2914,2915) and N.niveau_evaluation_id=NE.id order by quand desc001
80select T.topo_type_id from topos T where T.id=2914110
81select D.* from dernieres_descentes D where D.topo_id in (2915) order by D.quand desc001
82select 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=2914 or (T.topo_type_id=4 and T.parent_id=2914)) 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 asc001
83select 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 < 'Gouarege' 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 1115
84select 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 > 'Gouarege' 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 1115
85SELECT `TopoFacility`.`id`, `TopoFacility`.`topo_type_id`, `TopoFacility`.`nom`, `TopoFacility`.`nom2`, `TopoFacility`.`slug`, `TopoFacility`.`parent_id`, `TopoFacility`.`left`, `TopoFacility`.`right`, `TopoFacility`.`created`, `TopoFacility`.`modified`, `TopoFacility`.`riviere`, `TopoFacility`.`slugRiviere`, `TopoFacility`.`numero_ordre`, `TopoFacility`.`etat`, `TopoFacility`.`article`, `TopoFacility`.`situation_geographique`, `TopoFacility`.`presentation`, `TopoFacility`.`alimentation`, `TopoFacility`.`echelle`, `TopoFacility`.`debit`, `TopoFacility`.`qualite_eau`, `TopoFacility`.`temperature_eau`, `TopoFacility`.`source_niveaux`, `TopoFacility`.`periode_favorable`, `TopoFacility`.`risques_particuliers`, `TopoFacility`.`secours`, `TopoFacility`.`prestataires_eau_vive`, `TopoFacility`.`clubs_locaux`, `TopoFacility`.`bonnes_adresses`, `TopoFacility`.`bibliographie`, `TopoFacility`.`web_utiles`, `TopoFacility`.`commentaire`, `TopoFacility`.`img_carte`, `TopoFacility`.`url_carte`, `TopoFacility`.`reglementation_accords`, `TopoFacility`.`alternative_Basse`, `TopoFacility`.`alternative_Moyenne`, `TopoFacility`.`alternative_Haute`, `TopoFacility`.`niveau_temps_reel`, `TopoFacility`.`user_id`, `TopoFacility`.`user_2_id`, `TopoFacility`.`date_premiere_publication`, `TopoFacility`.`embarquement`, `TopoFacility`.`debarquement`, `TopoFacility`.`longueur`, `TopoFacility`.`distance`, `TopoFacility`.`pente_moyenne`, `TopoFacility`.`cotation`, `TopoFacility`.`physionomie`, `TopoFacility`.`logistique`, `TopoFacility`.`isolement`, `TopoFacility`.`paysage`, `TopoFacility`.`playboating`, `TopoFacility`.`duree`, `TopoFacility`.`guide_kilometrique`, `TopoFacility`.`date_derniere_descente`, `TopoFacility`.`caracteristiques`, `TopoFacility`.`renseignements`, `TopoType`.`id`, `TopoType`.`nom`, `TopoAlias`.`id`, `TopoAlias`.`topo_type_id`, `TopoAlias`.`nom`, `TopoAlias`.`slug`, `TopoAlias`.`parent_id`, `TopoAlias`.`left`, `TopoAlias`.`right`, `TopoAlias`.`created`, `TopoAlias`.`modified`, `TopoAlias`.`Migration_topo_id_original`, `Membre`.`user_id`, `Membre`.`user_type`, `Membre`.`user_regdate`, `Membre`.`username`, `Membre`.`username_clean`, `Membre`.`user_email`, `Membre`.`user_lastvisit`, `Membre`.`user_posts`, `Membre`.`user_avatar` FROM `topos_facility` AS `TopoFacility` LEFT JOIN `topo_types` AS `TopoType` ON (`TopoFacility`.`topo_type_id` = `TopoType`.`id`) LEFT JOIN `topos` AS `TopoAlias` ON (`TopoFacility`.`parent_id` = `TopoAlias`.`id`) LEFT JOIN `phpbb_users` AS `Membre` ON (`TopoFacility`.`user_id` = `Membre`.`user_id`) WHERE `TopoFacility`.`id` = 2914 111
86SELECT `NiveauReferencesDeNiveaux`.`id`, `NiveauReferencesDeNiveaux`.`niveau_stations_de_mesure_id`, `NiveauReferencesDeNiveaux`.`topo_id`, `NiveauReferencesDeNiveaux`.`niveau_references_de_niveau_type_id`, `NiveauReferencesDeNiveaux`.`min`, `NiveauReferencesDeNiveaux`.`max`, `NiveauReferencesDeNiveaux`.`publiable`, `NiveauReferencesDeNiveaux`.`user_id`, `NiveauReferencesDeNiveaux`.`commentaire`, `NiveauReferencesDeNiveaux`.`created`, `NiveauReferencesDeNiveaux`.`modified` FROM `niveau_references_de_niveaux` AS `NiveauReferencesDeNiveaux` WHERE `NiveauReferencesDeNiveaux`.`topo_id` = (2914) 000
87SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` = (2914) 110
88SELECT `CartoCoordonnee`.`id`, `CartoCoordonnee`.`objet_id`, `CartoCoordonnee`.`carto_type_id`, `CartoCoordonnee`.`carto_sous_type_id`, `CartoCoordonnee`.`lat`, `CartoCoordonnee`.`lon`, `CartoCoordonnee`.`alt`, `CartoCoordonnee`.`geocodage`, `CartoCoordonnee`.`encoded_coordinates`, `CartoCoordonnee`.`encoded_zooms`, `CartoCoordonnee`.`user_id`, `CartoCoordonnee`.`modified`, `CartoCoordonnee`.`created` FROM `carto_coordonnees` AS `CartoCoordonnee` WHERE carto_type_id IN (1, 2, 3) AND `CartoCoordonnee`.`objet_id` = (2914) 000
89SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (2914) 000
90SELECT `AttachmentsLink`.`id`, `AttachmentsLink`.`class`, `AttachmentsLink`.`foreign_id`, `AttachmentsLink`.`attachment_id`, `AttachmentsLink`.`created`, `AttachmentsLink`.`modified` FROM `attachments_links` AS `AttachmentsLink` WHERE `class` = 'Topo' AND `AttachmentsLink`.`foreign_id` = (2914) 000
91SELECT `Image`.`id`, `Image`.`class`, `Image`.`foreign_id`, `Image`.`filename`, `Image`.`slug`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`height`, `Image`.`width`, `Image`.`thumb`, `Image`.`description`, `Image`.`proprietaire`, `Image`.`proprietaire_url`, `Image`.`proprietaire_email`, `Image`.`user_id`, `Image`.`peut_illustrer`, `Image`.`created`, `Image`.`modified` FROM `attachments` AS `Image` WHERE `Image`.`class` = 'Topo' AND `Image`.`foreign_id` = (2914) 0010
Page rendered in 3787ms.