Riviere

L'Adour

France > Occitanie > Haute-Pyrénées (65)
punglas Par punglas | 26.01.2021

DESCRIPTION
Situation géographique
Département des Hautes-Pyrenées (65). Le fleuve adour nait à sainteMarie de Campan de la réunion de l'adour de Gripp et de l'adour de Payolle. Il se jette dans l'ocean vers Bayonne.
Présentation
Une partie sportive au -dessus de Bagnères de bigorre ou on a affaire à un très beau torrent Pyrénéen puis plus on descend et plus lke fleuve s'assagit.
Alimentation
Nivale
Période favorable
Printemps ou sur pluies. (à moins qu'il y ait des turbinages à Baudean ???).
Echelle
Plusieurs echelles sur le parcours dont uhe située dans Bagnères de Bigorre en amont du bassin de slalom.
60 à cette echelle est un niveau correct pour faire la descente depuis la centrale de Baudean (voir au dessus si on y trouve de l'eau !!).
Débit
Compter au moins 8 m3/s pour la section en amont de Bagnères (source Rivières Occitanes)
Sources niveaux
Echelle de Bagnères télétransmise sur vigicrues.
Niveau temps réél
60 à l'echelle de Bagnères semble être bon pour navguer dans le coin
Qualité de l'eau
Superbe
Température de l'eau
 
Risques particuliers
Arbres et digues
Secours
 
Prestataires
 
Clubs locaux
Club de Bagnères de Bigorre (club des champions Olympiques en C2 Adisson et Forgues).
Bonnes adresses
 
Bibliographie
Rivières Occitanes Tome 1 (Arenes/PuyhardY)
Rivières Sauvages (Patrick Santal).
Webs utiles
 
Réglementation, accords
Proscrire comme d'habitude les WE d'ouverture et fermeutre de la pêche.
Alternatives de navigation
  • Alternatives basses eaux : Bar, cafés, promenades, randonnées.
  • Alternatives moyennes eaux : Adour de Lesponne ou Arros à voir.
  • Alternatives hautes eaux : Arros à voir.
Commentaires
 
Commentaires
1
punglas Par punglas | 26.01.2021
Il y a auusi une station vigicrues à Campan qui s'appelle Campan [Payolle] , peut-être mesure t'elle le niveau de l'adour de Payolle. A confirmer Mais j'en ai des blablalkakaal

La rivière est un milieu vivant, changeant, et qui fait l'objet d'aménagements permanents. Les rédacteurs des topos rivières et les créateurs de ce site web ne peuvent en aucun cas être tenus pour responsables en cas d'inexactitude, d'omission ou d'erreur dans les topos rivières. Les rédacteurs de topos et les créateurs du site web déclinent toute responsabilité en cas d'accident pouvant survenir sur les rivières décrites dans ce guide.

(default) 76 queries took 63 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `dernieres_descentes`771
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
3SHOW FULL COLUMNS FROM `topo_commentaires`661
4SHOW FULL COLUMNS FROM `aide_edition_topos`771
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
6select T.id from topos T where T.slug = 'adour' and T.topo_type_id=1113
7select A.*,U.username, U.user_avatar from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=371 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 desc772
8SELECT `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` = 371 ORDER BY `TopoFacility`.`numero_ordre` asc 442
9SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
10SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
11SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
12SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
13SELECT `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` = 371 110
14SELECT `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` = 371 110
15SELECT `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` = 371 110
16SELECT `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` = 371 110
17SELECT `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` IN (2260, 1360, 2109, 2110) 220
18SELECT `NiveauStationsDeMesure`.`id`, `NiveauStationsDeMesure`.`nom`, `NiveauStationsDeMesure`.`niveau_source_donnee_id`, `NiveauStationsDeMesure`.`riviere`, `NiveauStationsDeMesure`.`web_adress2`, `NiveauStationsDeMesure`.`web_adress1`, `NiveauStationsDeMesure`.`comment`, `NiveauStationsDeMesure`.`actif`, `NiveauStationsDeMesure`.`created`, `NiveauStationsDeMesure`.`modified` FROM `niveau_stations_de_mesures` AS `NiveauStationsDeMesure` WHERE `NiveauStationsDeMesure`.`id` = 'V16-Q010003001' 110
19SELECT `NiveauDonneesTempsReel`.`id`, `NiveauDonneesTempsReel`.`niveau_stations_de_mesure_id`, `NiveauDonneesTempsReel`.`date_extraction`, `NiveauDonneesTempsReel`.`hauteur_d_eau`, `NiveauDonneesTempsReel`.`debit`, `NiveauDonneesTempsReel`.`pluie`, `NiveauDonneesTempsReel`.`autres_informations`, `NiveauDonneesTempsReel`.`IsLastInfo`, `NiveauDonneesTempsReel`.`IsNew`, `NiveauDonneesTempsReel`.`tendance`, `NiveauDonneesTempsReel`.`modified`, `NiveauDonneesTempsReel`.`created` FROM `niveau_donnees_temps_reels` AS `NiveauDonneesTempsReel` WHERE `IsLastInfo` = 0 AND `NiveauDonneesTempsReel`.`niveau_stations_de_mesure_id` = ('V16-Q010003001') 111
20SELECT `NiveauStationsDeMesure`.`id`, `NiveauStationsDeMesure`.`nom`, `NiveauStationsDeMesure`.`niveau_source_donnee_id`, `NiveauStationsDeMesure`.`riviere`, `NiveauStationsDeMesure`.`web_adress2`, `NiveauStationsDeMesure`.`web_adress1`, `NiveauStationsDeMesure`.`comment`, `NiveauStationsDeMesure`.`actif`, `NiveauStationsDeMesure`.`created`, `NiveauStationsDeMesure`.`modified` FROM `niveau_stations_de_mesures` AS `NiveauStationsDeMesure` WHERE `NiveauStationsDeMesure`.`id` = 'V23-Q000002001' 110
21SELECT `NiveauDonneesTempsReel`.`id`, `NiveauDonneesTempsReel`.`niveau_stations_de_mesure_id`, `NiveauDonneesTempsReel`.`date_extraction`, `NiveauDonneesTempsReel`.`hauteur_d_eau`, `NiveauDonneesTempsReel`.`debit`, `NiveauDonneesTempsReel`.`pluie`, `NiveauDonneesTempsReel`.`autres_informations`, `NiveauDonneesTempsReel`.`IsLastInfo`, `NiveauDonneesTempsReel`.`IsNew`, `NiveauDonneesTempsReel`.`tendance`, `NiveauDonneesTempsReel`.`modified`, `NiveauDonneesTempsReel`.`created` FROM `niveau_donnees_temps_reels` AS `NiveauDonneesTempsReel` WHERE `IsLastInfo` = 0 AND `NiveauDonneesTempsReel`.`niveau_stations_de_mesure_id` = ('V23-Q000002001') 111
22SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` IN (2260, 1360, 2109, 2110) 220
23SELECT `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` = 115 110
24SELECT `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` = 115 110
25SELECT `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` IN (2260, 1360, 2109, 2110) 441
26select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.id=371110
27select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 371)111
28select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=115 and CA.coordonnee_administrative_type_id=CAT.id110
29select 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
30select 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
31select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=371 and TP.topo_id=T.id order by TP.numero_ordre441
32select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2260)111
33select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1360)111
34select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2109)001
35select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2110)001
36select T.id,T.topo_type_id from topos T where T.parent_id=371 and T.topo_type_id=1000
37select T.parent_id from topos T where T.id=371110
38select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=371 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id111
39select 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=128110
40select C.* from topo_commentaires C where C.topo_id=371 order by C.created desc110
41SELECT `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` = 371 111
42SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 1 110
43SELECT `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` = (371) 000
44select 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
45SELECT `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` = 371 111
46SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (371) 001
47select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2260 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
48select 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=2260 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
49select 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=15581110
50select C.* from topo_commentaires C where C.topo_id=2260 order by C.created desc440
51select D.* from dernieres_descentes D where D.topo_id=2260 order by D.quand desc332
52select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2260 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc441
53select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1360 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
54select 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=1360 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
55select C.* from topo_commentaires C where C.topo_id=1360 order by C.created desc110
56select D.* from dernieres_descentes D where D.topo_id=1360 order by D.quand desc332
57select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1360 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc331
58select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2109 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id000
59select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2110 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id000
60select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (371,2260,1360,2109,2110) and N.niveau_evaluation_id=NE.id order by quand desc221
61select T.topo_type_id from topos T where T.id=371110
62select D.* from dernieres_descentes D where D.topo_id in (2260,1360,2109,2110) order by D.quand desc662
63select TP.numero_ordre from topos T,topo_parcours TP where T.id=2260 and TP.topo_id=T.id110
64select 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=16180110
65select TP.numero_ordre from topos T,topo_parcours TP where T.id=1360 and TP.topo_id=T.id110
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=1573110
67select 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=371 or (T.topo_type_id=4 and T.parent_id=371)) 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 asc221
68select 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 < 'adour' 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 1114
69select 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 > 'adour' 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 1117
70SELECT `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` = 371 111
71SELECT `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` = (371) 000
72SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` = (371) 110
73SELECT `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` = (371) 001
74SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (371) 000
75SELECT `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` = (371) 000
76SELECT `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` = (371) 0013
Page rendered in 2063ms.