Auvergne

(default) 43 queries took 46 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `coordonnees_administratives`991
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
3SHOW FULL COLUMNS FROM `coordonnee_administrative_types`221
4SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`331
5SHOW FULL COLUMNS FROM `topos`10101
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
7SHOW FULL COLUMNS FROM `topo_types`221
8SHOW FULL COLUMNS FROM `topo_bassins`221
9SHOW FULL COLUMNS FROM `topo_bassin_details`21211
10SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
11SHOW FULL COLUMNS FROM `phpbb_users`76762
12SHOW FULL COLUMNS FROM `topo_parcours`441
13SHOW FULL COLUMNS FROM `topo_parcours_details`25251
14SHOW FULL COLUMNS FROM `topo_rivieres`222
15SHOW FULL COLUMNS FROM `topo_riviere_details`35352
16SHOW FULL COLUMNS FROM `topo_spots`221
17SHOW FULL COLUMNS FROM `topo_spot_details`20202
18SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11112
19SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`10102
20SHOW FULL COLUMNS FROM `niveau_source_donnees`661
21SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`12122
22SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`221
23SHOW FULL COLUMNS FROM `niveaux`12121
24SHOW FULL COLUMNS FROM `niveau_evaluations`331
25SHOW FULL COLUMNS FROM `attachments`19191
26SHOW FULL COLUMNS FROM `attachments_links`661
27SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`12121
28SHOW FULL COLUMNS FROM `clubs_ffck`15152
29SHOW FULL COLUMNS FROM `petite_annonces`12121
30SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';111
31SHOW FULL COLUMNS FROM `petite_annonce_types`552
32SHOW FULL COLUMNS FROM `petite_annonce_categories`221
33SHOW FULL COLUMNS FROM `petite_annonce_matos_types`331
34SHOW FULL COLUMNS FROM `petite_annonce_commentaires`661
35SHOW FULL COLUMNS FROM `petite_annonce_disciplines`331
36SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`331
37SHOW FULL COLUMNS FROM `niveau_alertes`551
38SELECT CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END as region_nom, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as region_id, CASE CA.coordonnee_administrative_type_id WHEN 1 THEN CA.code ELSE NULL END as departement_code, CASE CA.coordonnee_administrative_type_id WHEN 1 THEN CA.nom ELSE '_Autre' END as departement_nom, 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 as etat, T.nom, T.id, T2.nom as riviere, T.*,T2.*,TP.*,TT.* 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 AND TPD.etat = 0 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 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END = 'Auvergne' 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_ordre59590
39SELECT CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END as region_nom, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as region_id, CASE CA.coordonnee_administrative_type_id WHEN 1 THEN CA.code ELSE NULL END as departement_code, CASE CA.coordonnee_administrative_type_id WHEN 1 THEN CA.nom ELSE '_Autre' END as departement_nom, 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 as etat, T.nom, T.id, T2.nom as riviere, T.*,T2.*,TP.*,TT.* 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 AND TPD.etat = 0 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 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END = 'Auvergne' 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_ordre47470
40SELECT CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END as region_nom, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as region_id, CASE CA.coordonnee_administrative_type_id WHEN 1 THEN CA.code ELSE NULL END as departement_code, CASE CA.coordonnee_administrative_type_id WHEN 1 THEN CA.nom ELSE '_Autre' END as departement_nom, 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 as etat, T.nom, T.id, T2.nom as riviere, T.*,T2.*,TP.*,TT.* 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 AND TPD.etat = 0 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 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END = 'Auvergne' 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_ordre770
41SELECT CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END as region_nom, CASE CA.coordonnee_administrative_type_id WHEN 2 THEN CA.id WHEN 1 THEN CA1.id ELSE NULL END as region_id, CASE CA.coordonnee_administrative_type_id WHEN 1 THEN CA.code ELSE NULL END as departement_code, CASE CA.coordonnee_administrative_type_id WHEN 1 THEN CA.nom ELSE '_Autre' END as departement_nom, 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 as etat, T.nom, T.id, T2.nom as riviere, T.*,T2.*,TP.*,TT.* 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 AND TPD.etat = 0 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 2 THEN CA.nom WHEN 1 THEN CA1.nom ELSE NULL END = 'Auvergne' 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_ordre550
42SELECT 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 WHERE CA.nom = 'Auvergne' ORDER BY UCASE(AL.annu_lien_name)asc 13130
43SELECT `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 22220