(default) 6 queries took 139 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT 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 = 'Picardie' 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_ordre9963
2SELECT 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 = 'Picardie' 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_ordre3346
3SELECT 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 = 'Picardie' 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_ordre4413
4SELECT 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 = 'Picardie' 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_ordre2210
5SELECT 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 = 'Picardie' ORDER BY UCASE(AL.annu_lien_name)asc 10107
6SELECT `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 20200