Riviere

La Semène

France > Auvergne-Rhône-Alpes > Haute-Loire (43)
By rems42 | 04.12.2002

DESCRIPTION
Geographic location
à 20 km au sud ouest de st etienne
Introduction
petite riviere IV V tres jolie assez soutenue pas tres large, manoeuvriere. Riviere descendant du pilat et se jettant dans la loire en rive droite.
Alimentation
pluviale
Période favorable
periode de pluie sur le massif du pilat
Echelle
minimum: margelle moins cinq centimetres (pont de semene à aurec)
a priori, le minimum correspond à 4.5 m3 à st didier en velay sur le lien DIREN
Débit
 
Sources niveaux
 
Niveau temps réél
echelle Diren Rhones-Alpes à Saint-Didier en Velay
http://www.rdbrmc.com/hydroreel2/station.php?codestation=509
Qualité de l'eau
bonne
Température de l'eau
fraiche
Risques particuliers
arbres
Secours
pompiers d'aurec
Prestataires
 
Clubs locaux
ckcf bllf
Bonnes adresses
 
Bibliographie
guide des 700 rivieres
Webs utiles
 
Réglementation, accords
 
Alternatives de navigation
  • Alternatives basses eaux : loire allier lignon
  • Alternatives moyennes eaux : allier limony lignon et toute les rivieres de haute loire
  • Alternatives hautes eaux : lignon loire allier
Commentaires
pas d'arbres à notre derniere descente (20/12/03)
Comments
4
By rems42 | 09.06.2008
attention un arbre coupe la riviere juste avant la partie qui envoi plus
il est visible, mais il y a peu de stop pour s'arreter il faut anticiper
By fil | 18.11.2006
Niveau en temps quasi réel:

http://www2.centre.ecologie.gouv.fr/schapi/SPC/choixSPC.do?nomSPC=SPC%20Loire%20Cher%20Indre

Une fois la carte affichée, sélectioner le zoom, puis rechercher la station LE CROUZET

Niveau mini pour naviguer: 4 m3
Niveau max: 10 m3


Voir plus de Comments

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) 125 queries took 108 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`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`661
46SHOW FULL COLUMNS FROM `aide_edition_topos`771
47select T.id from topos T where T.slug = 'semene' 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=127 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 desc15152
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` = 127 ORDER BY `TopoFacility`.`numero_ordre` asc 331
50SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
51SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
52SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 4 110
53SELECT `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` = 127 110
54SELECT `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` = 127 110
55SELECT `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` = 127 110
56SELECT `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 (2950, 1968, 1219) 220
57SELECT `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` = 'V10-K056752001' 110
58SELECT `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` = ('V10-K056752001') 112
59SELECT `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` = 'V10-K056752001' 110
60SELECT `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` = ('V10-K056752001') 110
61SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` IN (2950, 1968, 1219) 441
62SELECT `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` = 108 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 `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
65SELECT `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
66SELECT `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 (2950, 1968, 1219) 441
67select T.id,T.nom,T.slug,T.topo_type_id from topos T where T.id=127110
68select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 127)111
69select 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
70select 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
71select 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
72select T.id,T.nom,T.topo_type_id,TP.longueur,TP.numero_ordre from topos T,topo_parcours TP where T.parent_id=127 and TP.topo_id=T.id order by TP.numero_ordre331
73select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 2950)111
74select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1968)111
75select id from coordonnees_administratives where id in (select coordonnees_administrative_id from coordonnee_administrative_topos where topo_id = 1219)221
76select CA.id,CA.nom,CA.parent_id,CA.code,CAT.nom from coordonnees_administratives CA,coordonnee_administrative_types CAT where CA.id=108 and CA.coordonnee_administrative_type_id=CAT.id110
77select 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
78select T.id,T.topo_type_id from topos T where T.parent_id=127 and T.topo_type_id=1000
79select T.parent_id from topos T where T.id=127110
80select T.id,T.slug,T.topo_type_id,TRD.* from topos T,topo_rivieres TR,topo_riviere_details TRD where T.id=127 and TR.topo_id=T.id and TRD.topo_riviere_id=TR.id111
81select 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=318110
82select C.* from topo_commentaires C where C.topo_id=127 order by C.created desc440
83SELECT `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` = 127 111
84SELECT `TopoType`.`id`, `TopoType`.`nom` FROM `topo_types` AS `TopoType` WHERE `TopoType`.`id` = 1 110
85SELECT `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` = (127) 000
86select 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
87SELECT `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` = 127 111
88SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (127) 111
89select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=2950 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
90select 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=2950 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
91select 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=15936110
92select C.* from topo_commentaires C where C.topo_id=2950 order by C.created desc000
93select D.* from dernieres_descentes D where D.topo_id=2950 order by D.quand desc111
94select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=2950 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc222
95select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1968 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
96select 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=1968 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
97select 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=195110
98select C.* from topo_commentaires C where C.topo_id=1968 order by C.created desc220
99select D.* from dernieres_descentes D where D.topo_id=1968 order by D.quand desc332
100select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1968 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc332
101select TPD.etat from topos T,topo_parcours TP,topo_parcours_details TPD where T.id=1219 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id110
102select 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=1219 and TP.topo_id=T.id and TPD.topo_parcours_id=TP.id111
103select C.* from topo_commentaires C where C.topo_id=1219 order by C.created desc330
104select D.* from dernieres_descentes D where D.topo_id=1219 order by D.quand desc332
105select A.*,U.username, U.user_avatar from attachments A, attachments_links AL, phpbb_users U where AL.foreign_id=1219 and AL.class='Topo' and AL.attachment_id=A.id and A.user_id=U.user_id order by A.created desc10102
106select N.*, NE.name from niveaux N, niveau_evaluations NE where N.topo_id in (127,2950,1968,1219) and N.niveau_evaluation_id=NE.id order by quand desc222
107select T.topo_type_id from topos T where T.id=127110
108select D.* from dernieres_descentes D where D.topo_id in (2950,1968,1219) order by D.quand desc772
109select 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=3402110
110select TP.numero_ordre from topos T,topo_parcours TP where T.id=1968 and TP.topo_id=T.id110
111select TP.numero_ordre from topos T,topo_parcours TP where T.id=2950 and TP.topo_id=T.id110
112select 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
113select TP.numero_ordre from topos T,topo_parcours TP where T.id=1219 and TP.topo_id=T.id110
114select 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=11446110
115select 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=127 or (T.topo_type_id=4 and T.parent_id=127)) 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 asc111
116select 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 < 'semene' 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
117select 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 > 'semene' 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 1114
118SELECT `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` = 127 111
119SELECT `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` = (127) 000
120SELECT `CoordonneeAdministrativeTopo`.`id`, `CoordonneeAdministrativeTopo`.`coordonnees_administrative_id`, `CoordonneeAdministrativeTopo`.`topo_id` FROM `coordonnee_administrative_topos` AS `CoordonneeAdministrativeTopo` WHERE `CoordonneeAdministrativeTopo`.`topo_id` = (127) 110
121SELECT `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` = (127) 000
122SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`topo_id` = (127) 110
123SELECT `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` = (127) 000
124SELECT `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` = (127) 0010
125select 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
Page rendered in 4906ms.