La Carto'EVO
optimized for a 1280 * 1024 screen resolution and Firefox web browser
GPS - GoogleEarth



Search a city, an address

You are not connected.
For more options: Log-in
Click here Add a point
(*) -> l'objet n'existe pas encore sur la carto

(*) peut être long à afficher
Developed by punglas.
Icons designed by splitwee.
Waiting icon by john.
(default) 7 queries took 100 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1 SELECT DISTINCT CT.nom as 'type', CC.objet_id, CC.carto_type_id, CC.carto_sous_type_id, CC.lat, CC.lon, CC.alt, CC.id, CC.user_id, U.username, U.username_clean, T.id, T.slug, T.topo_type_id, TPD.cotation, TPD.user_id, TBD.user_id, TSD.user_id, CASE T.topo_type_id WHEN 4 THEN TPD.user_id WHEN 3 THEN TBD.user_id WHEN 2 THEN TSD.user_id ELSE NULL END as user2_id, TP.numero_ordre as numero_ordre, CASE T.topo_type_id WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) ELSE T.nom END as nom, concat(A.dir,'/',A.filename) as url, CASE T.topo_type_id WHEN 4 THEN T2.nom ELSE T.nom END as riviere, CASE T.topo_type_id WHEN 4 THEN T2.slug ELSE T.slug END as slug_riviere, CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END as id_riviere FROM `carto_coordonnees` CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id -- Topos INNER JOIN topos T ON CC.`objet_id` = T.id 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_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 -- Coordonnes administratives -- 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 -- User INNER JOIN phpbb_users U ON CC.user_id=U.user_id -- Photo LEFT JOIN attachments_links_rand AL ON T.id = AL.foreign_id and AL.class='Topo' LEFT JOIN attachments A ON AL.attachment_id=A.id WHERE `carto_type_id` < 5 and CC.carto_type_id in (2) AND T.ID is null ORDER BY carto_type_id, nom;001
2 SELECT DISTINCT CT.nom as 'type', CC.objet_id, CC.carto_type_id, CC.carto_sous_type_id, CC.lat, CC.lon, CC.alt, CC.id, CC.user_id, U.username, U.username_clean, T.id, T.slug, T.topo_type_id, TPD.cotation, TPD.user_id, TBD.user_id, TSD.user_id, CASE T.topo_type_id WHEN 4 THEN TPD.user_id WHEN 3 THEN TBD.user_id WHEN 2 THEN TSD.user_id ELSE NULL END as user2_id, TP.numero_ordre as numero_ordre, CASE T.topo_type_id WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) ELSE T.nom END as nom, concat(A.dir,'/',A.filename) as url, CASE T.topo_type_id WHEN 4 THEN T2.nom ELSE T.nom END as riviere, CASE T.topo_type_id WHEN 4 THEN T2.slug ELSE T.slug END as slug_riviere, CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END as id_riviere FROM `carto_coordonnees` CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id -- Topos INNER JOIN topos T ON CC.`objet_id` = T.id 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_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 -- Coordonnes administratives -- 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 -- User INNER JOIN phpbb_users U ON CC.user_id=U.user_id -- Photo LEFT JOIN attachments_links_rand AL ON T.id = AL.foreign_id and AL.class='Topo' LEFT JOIN attachments A ON AL.attachment_id=A.id WHERE `carto_type_id` < 5 and CC.carto_type_id in (3) AND T.ID is null ORDER BY carto_type_id, nom;001
3 SELECT DISTINCT CT.nom as 'type', CC.objet_id, CC.carto_type_id, CC.carto_sous_type_id, CC.lat, CC.lon, CC.alt, CC.id, CC.user_id, U.username, U.username_clean, T.id, T.slug, T.topo_type_id, TPD.cotation, TPD.user_id, TBD.user_id, TSD.user_id, CASE T.topo_type_id WHEN 4 THEN TPD.user_id WHEN 3 THEN TBD.user_id WHEN 2 THEN TSD.user_id ELSE NULL END as user2_id, TP.numero_ordre as numero_ordre, CASE T.topo_type_id WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) ELSE T.nom END as nom, concat(A.dir,'/',A.filename) as url, CASE T.topo_type_id WHEN 4 THEN T2.nom ELSE T.nom END as riviere, CASE T.topo_type_id WHEN 4 THEN T2.slug ELSE T.slug END as slug_riviere, CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END as id_riviere FROM `carto_coordonnees` CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id -- Topos INNER JOIN topos T ON CC.`objet_id` = T.id 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_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 -- Coordonnes administratives -- 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 -- User INNER JOIN phpbb_users U ON CC.user_id=U.user_id -- Photo LEFT JOIN attachments_links_rand AL ON T.id = AL.foreign_id and AL.class='Topo' LEFT JOIN attachments A ON AL.attachment_id=A.id WHERE `carto_type_id` < 5 and CC.carto_type_id in (1) AND T.ID in ('2903') ORDER BY carto_type_id, nom;2258
4 SELECT DISTINCT CT.nom as 'type', CC.objet_id, CC.carto_type_id, CC.carto_sous_type_id, CC.lat, CC.lon, CC.alt, CC.id, CC.user_id, U.username, U.username_clean, T.id, T.slug, T.topo_type_id, TPD.cotation, TPD.user_id, TBD.user_id, TSD.user_id, CASE T.topo_type_id WHEN 4 THEN TPD.user_id WHEN 3 THEN TBD.user_id WHEN 2 THEN TSD.user_id ELSE NULL END as user2_id, TP.numero_ordre as numero_ordre, CASE T.topo_type_id WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) ELSE T.nom END as nom, concat(A.dir,'/',A.filename) as url, CASE T.topo_type_id WHEN 4 THEN T2.nom ELSE T.nom END as riviere, CASE T.topo_type_id WHEN 4 THEN T2.slug ELSE T.slug END as slug_riviere, CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END as id_riviere FROM `carto_coordonnees` CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id -- Topos INNER JOIN topos T ON CC.`objet_id` = T.id 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_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 -- Coordonnes administratives -- 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 -- User INNER JOIN phpbb_users U ON CC.user_id=U.user_id -- Photo LEFT JOIN attachments_links_rand AL ON T.id = AL.foreign_id and AL.class='Topo' LEFT JOIN attachments A ON AL.attachment_id=A.id WHERE `carto_type_id` < 5 and CC.carto_type_id in (1) AND CASE T.topo_type_id WHEN 4 THEN T2.id ELSE T.id END is null ORDER BY carto_type_id, nom;0040
5SELECT CT.nom as 'type', CC.objet_id, CC.carto_type_id, CC.carto_sous_type_id, CC.lat, CC.lon, CC.alt, CC.id, CC.user_id, replace(phpbb_users.user_id,'rien','') as user2_id, replace(phpbb_users.username,'rien','') as nom, -- phpbb_users.M_BIO, -- phpbb_users.M_CITY, replace(phpbb_users.user_avatar,'rien','') as url FROM carto_coordonnees CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id INNER JOIN phpbb_users ON CC.objet_id = phpbb_users.user_id WHERE CC.carto_type_id = 5 AND phpbb_users.user_id is null ORDER BY group_id desc, phpbb_users.username asc ;000
6SELECT CT.nom as 'type', CC.objet_id, CC.carto_type_id, CC.carto_sous_type_id, CC.lat, CC.lon, CC.alt, CC.id, CC.user_id, concat(Code_structure_ffck, ' - ',clubs_ffck.Nom) as nom, clubs_ffck.nom, clubs_ffck.Code_structure_ffck, clubs_ffck.adresse1, clubs_ffck.adresse2, clubs_ffck.code_postal, clubs_ffck.ville, clubs_ffck.site_web FROM carto_coordonnees CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id INNER JOIN clubs_ffck ON CC.objet_id = clubs_ffck.code_structure_ffck WHERE CC.carto_type_id = 6 AND clubs_ffck.Code_structure_ffck is null ORDER BY clubs_ffck.code_structure_ffck, clubs_ffck.Nom asc ;000
7SELECT `CartoType`.`id`, `CartoType`.`nom` FROM `carto_types` AS `CartoType` WHERE 1 = 1 550