Parcours

L'Allier P6

Monistrol - Prades
France > Auvergne-Rhône-Alpes > Haute-Loire (43)
Par road-man |

Résumé
12 km
  de Cl  
III-IV E1
Monistrol
Prades
DESCRIPTION
Présentation
Cette partie de riviere est sportive et elle est la plus empruntée de la vallée.Les rapides de classe II et III sont nombreux sur la première partie de la rivière. De petits rapides classés IV.

La navigation est autorisée de 10 h à 18h30 et elle est interdite du 31 octobre au 15 mars.
Physionomie
Rivière typique du massif central avec enchaînement de rapides et de grands plats permettant la récupération du matériel.
Pente
 
Logistique
De Langeac prendre la D48 popur aller jusqu'à Prades, ensuite apres avoir emprunter le pont de prades prendre la D301 en montant sur la colline puis continuer jusqu'à Monistrol d'allier.
L'embarquement se fait 50m en aval du pont routier, rive gauche de Monistrol d'allier.Le débarquement a lieu rive gauche, en amont du pont routier.

Monistrol est à environ 30 km du Puy en Velay.
Paysage
Belles gorges. Superbe à l'arrivée sur Prades avec "les orgues de Prades"
Isolement
Bon (seule la voie ferrée longe la rivière)
Potentiel playboating
Pas mal par bon niveau, de belles vagues à surf à la fin des rapides.
Durée
3h
Au fil de l'eau
Deux beaux rapides ponctuent la descente:
-2.5 km après le départ: rapide de "la-roche qui-pleure"(classe IV). Il est nécessaire de franchir lma derniere partie par la gauche afin d'éviter de tomber dans le rouleau produit par la "Roche".
-3.5 km: rapide de la "Baraque-à-Ponnet"(IV),très caractéristique par sa longueur (300m) et sa succesion de vagues.L'entrée est à droite et la sortie à gauche.

En aval de Pont-Gilbert, au km 7.5 : la grille de Chardassac(III).La riviere s'élargit et s'assagit(II) pour aboutir au village de Prades.
Dernière descente
30/04/2005
Commentaires
10
punglas Par punglas | 27.05.2023
test comm
théo Par théo | 19.02.2018
Les principaux passages dans l'ordre : -premier rapide d'échauffement tout droit, 3 vagues surfables. -le drossage (par basses eau et si pas d'arbre on peut passer derrière la falaise sur laquelle ça drosse, c'est très sympa). -le trou du curé. -la benne (en face falaise d'orgues avec coulures rouges) : 3 bras, bras de gauche (pif) en kayak de descente ce bras de passe qu'à partir de +-15m3, le bras principal au milieu (paf) passe mal en dessous de 20m3, le bras de droite (pouf) est le plus fun petit rouleau et ça drosse à droite à la fin. -la table : en bateau de descente c'est à gauche. -la roche qui pleure juste après : plus on passe à droite plus ça secoue... à gauche pas de soucis. -la baraque à poneys. -première grille -avalator (rouleau qui ne se forme que par certains niveaux et rince violemment les sinus !) -2ème grille. -falaise pour faire des sauts (elle est peut-être entre les 2 grilles, je suis plus sûr).
Voir plus de Commentaires
Descentes
5
Par voyageur | 03.05.2013
Descente effectuée le 29-04-2013
fait a 35m3, parcours propre, tout se navigue a vue. joli parcours, une premiere pour nous.
punglas Par punglas | 07.07.2010
Descente effectuée le 05-07-2010
Fait à 9 m3/s, ca passe. RAs sur le parcours.
Voir plus de Descentes
Photos
17
Cliquer sur la photo pour voir le diaporama,
ou sur cette icone pour voir la photo originale
(s'ouvre dans une nouvelle fenêtre).
mctony Par mctony | 05.05.2023
la baraque de PONNET à l'origine du nom du fameux rapide !
Théo Par Théo | 19.02.2018
Gaetan de Brioude sur la table avec un peu d'eau.
Par ksyrium | 13.01.2018
La baraque à poney à 27m2
Par ksyrium | 13.01.2018
la roche qui pleure à 27m2.
Voir plus de photos

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) 205 queries took 181 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`25252
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`24241
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`662
46SHOW FULL COLUMNS FROM `aide_edition_topos`772
47select T.id from topos T where T.slug = 'allier' and T.topo_type_id=1113
48select TP.numero_ordre from topos T,topo_parcours TP where T.id=1285 and TP.topo_id=T.id110
49select 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=1285 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
50select 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=383111
51select 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=66110
52select C.* from topo_commentaires C where C.topo_id=1285 order by C.created desc10101
53select D.* from dernieres_descentes D where D.topo_id=1285 order by D.quand desc552
54select A.*,U.username, U.user_avatar from attachments A,attachments_links AL,phpbb_users U,topos T where T.parent_id=122 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 desc62624
55select A.*,U.username, U.user_avatar from attachments A,attachments_links AL,phpbb_users U,topos T where T.id=1285 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 desc17172
56SELECT `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`.`id` = 1285 ORDER BY `TopoFacility`.`numero_ordre` asc 111
57SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
58SELECT `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` = 122 110
59SELECT `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` = (1285) 111
60SELECT `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` = 'V11-K224082001' 110
61SELECT `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` = ('V11-K224082001') 112
62SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` = (1285) 110
63SELECT `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` = 127 110
64SELECT `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` = (1285) 221
65SELECT `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`.`parent_id` = 122 AND `TopoFacility`.`numero_ordre` = 7 111
66SELECT `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` = (2169) 001
67SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` = (2169) 111
68SELECT `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` = (2169) 221
69SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (2169) 001
70SELECT `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` = (2169) 001
71SELECT `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` = (2169) 0011
72select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.id=122110
73select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 122)111
74select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=127 and CA.coordonnee_administrative_type_id=CAT.id110
75select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=262 and CA.coordonnee_administrative_type_id=CAT.id110
76select 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
77select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=122 and TP.topo_id=T.id order by TP.numero_ordre11111
78select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2706)111
79select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1015)111
80select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1016)111
81select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1292)111
82select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2747)111
83select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1285)111
84select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2169)111
85select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2170)111
86select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2171)111
87select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2748)111
88select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1686)001
89select T.id,T.topo_type_id from topos T where T.parent_id=122 and T.topo_type_id=1000
90select T.parent_id from topos T where T.id=122110
91select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=122 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id111
92select 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=602110
93select C.* from topo_commentaires C where C.topo_id=122 order by C.created desc881
94SELECT `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` = 122 111
95SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 1 110
96SELECT `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` = (122) 221
97SELECT `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` = 'V11-K209081001' 111
98SELECT `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` = ('V11-K209081001') 112
99SELECT `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` = 'V11-K207081010' 110
100SELECT `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` = ('V11-K207081010') 112
101select 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
102SELECT `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` = 1285 111
103SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (1285) 111
104select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2706 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
105select 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=2706 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
106select 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=10363110
107select C.* from topo_commentaires C where C.topo_id=2706 order by C.created desc000
108select D.* from dernieres_descentes D where D.topo_id=2706 order by D.quand desc001
109select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2706 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc001
110select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1015 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
111select 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=1015 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
112select C.* from topo_commentaires C where C.topo_id=1015 order by C.created desc881
113select D.* from dernieres_descentes D where D.topo_id=1015 order by D.quand desc992
114select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1015 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc18182
115select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1016 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
116select 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=1016 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
117select C.* from topo_commentaires C where C.topo_id=1016 order by C.created desc881
118select D.* from dernieres_descentes D where D.topo_id=1016 order by D.quand desc662
119select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1016 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc10102
120select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1292 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
121select 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=1292 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
122select 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=56110
123select C.* from topo_commentaires C where C.topo_id=1292 order by C.created desc771
124select D.* from dernieres_descentes D where D.topo_id=1292 order by D.quand desc222
125select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1292 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc771
126select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2747 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
127select 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=2747 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
128select 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=6379110
129select C.* from topo_commentaires C where C.topo_id=2747 order by C.created desc881
130select D.* from dernieres_descentes D where D.topo_id=2747 order by D.quand desc002
131select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2747 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc882
132select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1285 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
133select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1285 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc17172
134select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2169 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
135select 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=2169 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
136select 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=5299110
137select C.* from topo_commentaires C where C.topo_id=2169 order by C.created desc110
138select D.* from dernieres_descentes D where D.topo_id=2169 order by D.quand desc001
139select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2169 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc001
140select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2170 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
141select 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=2170 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
142select C.* from topo_commentaires C where C.topo_id=2170 order by C.created desc110
143select D.* from dernieres_descentes D where D.topo_id=2170 order by D.quand desc001
144select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2170 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc001
145select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2171 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
146select 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=2171 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
147select C.* from topo_commentaires C where C.topo_id=2171 order by C.created desc110
148select D.* from dernieres_descentes D where D.topo_id=2171 order by D.quand desc001
149select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2171 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc111
150select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2748 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
151select 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=2748 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
152select C.* from topo_commentaires C where C.topo_id=2748 order by C.created desc000
153select D.* from dernieres_descentes D where D.topo_id=2748 order by D.quand desc001
154select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2748 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc111
155select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1686 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id000
156select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (122,2706,1015,1016,1292,2747,1285,2169,2170,2171,2748,1686) and N.niveau_evaluation_id=NE.id order by quand desc001
157select T.topo_type_id from topos T where T.id=122110
158select D.* from dernieres_descentes D where D.topo_id in (2706,1015,1016,1292,2747,1285,2169,2170,2171,2748,1686) order by D.quand desc22222
159select 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=15441110
160select TP.numero_ordre from topos T,topo_parcours TP where T.id=1016 and TP.topo_id=T.id110
161select 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=11604110
162select TP.numero_ordre from topos T,topo_parcours TP where T.id=1015 and TP.topo_id=T.id110
163select 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=10916110
164select 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=11810110
165select TP.numero_ordre from topos T,topo_parcours TP where T.id=1292 and TP.topo_id=T.id110
166select 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=3801110
167select 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=13222110
168select 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
169select 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=3948110
170select 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=9976110
171select 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=2990110
172select 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=131110
173select 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=62110
174select 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=122 or (T.topo_type_id=4 and T.parent_id=122)) 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 asc551
175select 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 < 'allier' 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
176select 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 > 'allier' 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
177SELECT `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` = 1285 111
178SELECT `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` = (1285) 110
179SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` = (1285) 110
180SELECT `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` = (1285) 220
181SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (1285) 110
182SELECT `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` = (1285) 17171
183SELECT `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` = (1285) 171710
184SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
185SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
186SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
187SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
188SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
189SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
190SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
191SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
192SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
193SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
194SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
195SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
196SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
197SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
198SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
199SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
200SELECT `Topo`.`id`, `Topo`.`nom` FROM `topos` AS `Topo` WHERE `Topo`.`id` = 1285 LIMIT 1110
Page rendered in 17668ms.