Guide des régions Suisse - Eauxvives.org

Suisse

31 Rivieres - 0 Bassins - 0 Spots - 8 Sites web

Bern

Riviere

Graubünden

Riviere
- Glenner
- Hinterrhein
- Inn
- Landquart
- Medelsbach

Suisse Centrale

Riviere
- Entlen
- Furkareuss
- Kleine Emme
- Meienreuss
- Muota
- Reuss

Suisse Est

Riviere
- Rhin Antérieur (Vorderrhein)

Suisse Ouest

Riviere
- Versoix

Suisse Sud

Riviere
- Calancasca
- Isorno
- Melezza
- Moesa
- Ossola
- Ribo
- Rovana
- Tessin
- Verzasca

Wallis

Riviere
- Dranse d'Entremont et de Martigny
- Rhône

Sites Web (8)

(default) 6 queries took 139 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT T.,T2., TP.,TT., CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as departement_code, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE '_Others' END as departement_nom, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.id WHEN 2 THEN CA1.id WHEN 1 THEN CA2.id ELSE NULL END as pays_id, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END as pays_nom FROM topos T LEFT JOIN topos T2 ON T.parent_id=T2.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_types TT ON T.topo_type_id=TT.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 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_rivieres TR ON TR.topo_id=T.id LEFT JOIN topo_riviere_details TRD ON TRD.topo_riviere_id=TR.id INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=T.id INNER JOIN coordonnees_administratives CA ON CAT.coordonnees_administrative_id=CA.id LEFT JOIN coordonnees_administratives CA1 ON CA.parent_id=CA1.id LEFT JOIN coordonnees_administratives CA2 ON CA1.parent_id=CA2.id WHERE CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END = 'Suisse' AND (CASE T.topo_type_id WHEN 1 THEN TRD.etat WHEN 2 THEN TSD.etat WHEN 3 THEN TBD.etat WHEN 4 THEN TPD.etat END)=0 AND T.topo_type_id <>4 ORDER BY departement_nom, T.topo_type_id, T.nom,TP.numero_ordre		31	31	63
2	SELECT T.,T2., TP.,TT., CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as departement_code, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE '_Others' END as departement_nom, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.id WHEN 2 THEN CA1.id WHEN 1 THEN CA2.id ELSE NULL END as pays_id, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END as pays_nom FROM topos T LEFT JOIN topos T2 ON T.parent_id=T2.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_types TT ON T.topo_type_id=TT.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 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_rivieres TR ON TR.topo_id=T.id LEFT JOIN topo_riviere_details TRD ON TRD.topo_riviere_id=TR.id INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=T.id INNER JOIN coordonnees_administratives CA ON CAT.coordonnees_administrative_id=CA.id LEFT JOIN coordonnees_administratives CA1 ON CA.parent_id=CA1.id LEFT JOIN coordonnees_administratives CA2 ON CA1.parent_id=CA2.id WHERE CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END = 'Suisse' AND (CASE T.topo_type_id WHEN 1 THEN TRD.etat WHEN 2 THEN TSD.etat WHEN 3 THEN TBD.etat WHEN 4 THEN TPD.etat END)=0 AND T.topo_type_id <>4 AND T.topo_type_id = 1 ORDER BY departement_nom, T.topo_type_id, T.nom,TP.numero_ordre		31	31	46
3	SELECT T.,T2., TP.,TT., CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as departement_code, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE '_Others' END as departement_nom, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.id WHEN 2 THEN CA1.id WHEN 1 THEN CA2.id ELSE NULL END as pays_id, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END as pays_nom FROM topos T LEFT JOIN topos T2 ON T.parent_id=T2.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_types TT ON T.topo_type_id=TT.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 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_rivieres TR ON TR.topo_id=T.id LEFT JOIN topo_riviere_details TRD ON TRD.topo_riviere_id=TR.id INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=T.id INNER JOIN coordonnees_administratives CA ON CAT.coordonnees_administrative_id=CA.id LEFT JOIN coordonnees_administratives CA1 ON CA.parent_id=CA1.id LEFT JOIN coordonnees_administratives CA2 ON CA1.parent_id=CA2.id WHERE CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END = 'Suisse' AND (CASE T.topo_type_id WHEN 1 THEN TRD.etat WHEN 2 THEN TSD.etat WHEN 3 THEN TBD.etat WHEN 4 THEN TPD.etat END)=0 AND T.topo_type_id <>4 AND T.topo_type_id = 2 ORDER BY departement_nom, T.topo_type_id, T.nom,TP.numero_ordre		0	0	13
4	SELECT T.,T2., TP.,TT., CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as departement_code, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE '_Others' END as departement_nom, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.id WHEN 2 THEN CA1.id WHEN 1 THEN CA2.id ELSE NULL END as pays_id, CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END as pays_nom FROM topos T LEFT JOIN topos T2 ON T.parent_id=T2.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_types TT ON T.topo_type_id=TT.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 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_rivieres TR ON TR.topo_id=T.id LEFT JOIN topo_riviere_details TRD ON TRD.topo_riviere_id=TR.id INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=T.id INNER JOIN coordonnees_administratives CA ON CAT.coordonnees_administrative_id=CA.id LEFT JOIN coordonnees_administratives CA1 ON CA.parent_id=CA1.id LEFT JOIN coordonnees_administratives CA2 ON CA1.parent_id=CA2.id WHERE CASE CA.coordonnee_administrative_type_id WHEN 3 THEN CA.nom WHEN 2 THEN CA1.nom WHEN 1 THEN CA2.nom ELSE NULL END = 'Suisse' AND (CASE T.topo_type_id WHEN 1 THEN TRD.etat WHEN 2 THEN TSD.etat WHEN 3 THEN TBD.etat WHEN 4 THEN TPD.etat END)=0 AND T.topo_type_id <>4 AND T.topo_type_id = 3 ORDER BY departement_nom, T.topo_type_id, T.nom,TP.numero_ordre		0	0	9
5	SELECT distinct AL.annu_lien_name, AL.annu_lien_url FROM phpbb_annuaire_liens AL INNER JOIN coordonnees_administratives CA ON AL.annu_lien_region=CA.id LEFT JOIN coordonnees_administratives CA2 ON CA.parent_id = CA2.id WHERE CA.nom = 'Suisse' OR CA2.nom = 'Suisse' ORDER BY UCASE(AL.annu_lien_name)asc		8	8	8
6	SELECT `CoordonneesAdministrative`.`id`, `CoordonneesAdministrative`.`nom`, `CoordonneesAdministrative`.`slug`, `CoordonneesAdministrative`.`code`, `CoordonneesAdministrative`.`coordonnee_administrative_type_id`, `CoordonneesAdministrative`.`parent_id`, `CoordonneesAdministrative`.`lft`, `CoordonneesAdministrative`.`rght`, `CoordonneesAdministrative`.`Migration`, `CoordonneeAdministrativeType`.`id`, `CoordonneeAdministrativeType`.`nom` FROM `coordonnees_administratives` AS `CoordonneesAdministrative` LEFT JOIN `coordonnee_administrative_types` AS `CoordonneeAdministrativeType` ON (`CoordonneesAdministrative`.`coordonnee_administrative_type_id` = `CoordonneeAdministrativeType`.`id`) WHERE `CoordonneeAdministrativeType`.`nom` = 'Région' AND `parent_id` = 1 ORDER BY `CoordonneesAdministrative`.`nom` asc		20	20	0