- © Team EVO - 2008,2009
(default) 37 queries took 452 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1 SELECT Topics.topic_id, Topics.topic_title, Forums.forum_name, Topics.topic_last_post_time,Topics.topic_replies, Topics.topic_last_post_id FROM phpbb_topics Topics INNER JOIN phpbb_forums Forums on Topics.forum_id = Forums.forum_id WHERE Topics.forum_id not in (13,15,34,46,4,23,24,25,26,32,33,35,38,41,45,48,49,50,51,53,54,"28") ORDER BY Topics.topic_last_post_time DESC limit 1515151
2SELECT * FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id INNER JOIN topos Topo ON AL.foreign_id=Topo.id INNER JOIN topo_types TT on Topo.topo_type_id=TT.id LEFT JOIN topos T2 ON Topo.parent_id=T2.id LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 ORDER BY rand() ASC LIMIT 111401
3SELECT 'Parcours' AS type_icone , 'topos' AS type , 'Parcours' AS label_icone , T.id AS id, T.slug AS slug, T2.slug as slug_riviere, TP.numero_ordre as numero_ordre, concat( T2.nom, ' P', TP.numero_ordre ) AS nom, TPD.modified AS date FROM `topo_parcours_details` TPD INNER JOIN topo_parcours TP ON TP.id = TPD.`topo_parcours_id` INNER JOIN topos T ON TP.topo_id = T.id INNER JOIN topos T2 ON T.parent_id = T2.id WHERE TPD.etat = 0 union all SELECT 'Riviere' AS type_icone , 'topos' AS type , 'Riviere' AS label_icone , T.id AS id, T.slug AS slug, null as slug_riviere, null as numero_ordre, TRD.nom AS nom, TRD.modified AS date FROM `topo_riviere_details` TRD INNER JOIN topo_rivieres TR ON TR.id = TRD.topo_riviere_id INNER JOIN topos T ON TR.topo_id = T.id WHERE TRD.etat = 0 union all SELECT 'Bassin' AS type_icone , 'topos' AS type , 'Bassin' AS label_icone , T.id AS id, T.slug AS slug, null as slug_riviere, null as numero_ordre,TBD.nom AS nom, TBD.date_premiere_publication AS date FROM `topo_bassin_details` TBD INNER JOIN topo_bassins TB ON TB.id = TBD.`topo_bassin_id` INNER JOIN topos T ON TB.topo_id = T.id WHERE TBD.etat = 0 union all SELECT 'Spot' AS type_icone, 'topos' AS type , 'Spot' AS label_icone, T.id AS id, T.slug AS slug, null as slug_riviere, null as numero_ordre,TSD.nom AS nom, TSD.date_premiere_publication AS date FROM `topo_spot_details` TSD INNER JOIN topo_spots TS ON TS.id = TSD.`topo_spot_id` INNER JOIN topos T ON TS.topo_id = T.id WHERE TSD.etat = 0 union all SELECT 'Parcours' AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, T.id AS id, T.slug AS slug, T2.slug AS slug_riviere, TP.numero_ordre AS numero_ordre, concat( T2.nom, ' P', TP.numero_ordre ) AS nom, TC.created AS date FROM topo_commentaires TC INNER JOIN topos T ON TC.topo_id = T.id INNER JOIN topos T2 ON T.parent_id = T2.id INNER JOIN topo_parcours TP ON TP.topo_id = T.id INNER JOIN topo_parcours_details TPD ON TP.id = TPD.topo_parcours_id WHERE T.topo_type_id =4 union all SELECT distinct 'Spot' AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, TC.created AS date FROM topo_commentaires TC INNER JOIN topos T ON TC.topo_id = T.id WHERE T.topo_type_id = 2 union all SELECT distinct 'Bassin' AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, TC.created AS date FROM topo_commentaires TC INNER JOIN topos T ON TC.topo_id = T.id WHERE T.topo_type_id = 3 union all SELECT distinct 'Riviere' AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, TC.created AS date FROM topo_commentaires TC INNER JOIN topos T ON TC.topo_id = T.id WHERE T.topo_type_id = 1 union all SELECT DISTINCT 'Carto' AS type_icone, 'Carto' AS type , 'Carto' AS label_icone, min(CC.id) AS id, min(T.slug) AS slug, min(T.slug) AS slug_riviere, 0 AS numero_ordre, min(CASE T.topo_type_id WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) ELSE T.nom END) as nom, min(CC.created) AS date FROM `carto_coordonnees` CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id INNER JOIN topos T ON CC.`objet_id` = T.id and carto_type_id not in (5,6) 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 group by CC.objet_id union all SELECT DISTINCT 'RefNiveau' AS type_icone, 'RefNiveau' AS type , 'Niveau calibrage' AS label_icone, CASE T.topo_type_id WHEN 4 THEN T.parent_id ELSE RN.topo_id END AS id, min(T.slug) AS slug, min(T.slug) AS slug_riviere, RN.topo_id AS numero_ordre, min(CASE T.topo_type_id WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) ELSE T.nom END) as nom, min(RN.modified) AS date FROM `niveau_references_de_niveaux` RN INNER JOIN topos T ON RN.`topo_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 group by RN.topo_id order by date desc limit 1515150
4SELECT 'Parcours' AS type_icone , 'dernieres_descentes' AS type , 'Dernière descente' AS label_icone , T.id AS id, T.slug AS slug, T2.slug as slug_riviere, TP.numero_ordre as numero_ordre, concat( T2.nom, ' P', TP.numero_ordre ) AS nom, DD.quand AS date FROM dernieres_descentes DD INNER JOIN topos T ON DD.topo_id = T.id INNER JOIN topos T2 ON T.parent_id = T2.id INNER JOIN topo_parcours TP ON TP.topo_id = T.id INNER JOIN topo_parcours_details TPD ON TP.id = TPD.topo_parcours_id WHERE T.topo_type_id=4 union all SELECT distinct CASE IF(T.topo_type_id is NULL,0,T.topo_type_id) WHEN 0 THEN 'Niveau' WHEN 1 THEN 'Riviere' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 4 THEN 'Parcours' ELSE 'Error' END as type_icone, 'niveaux' AS type , 'Niveau' as label_icone, N.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, CASE IF(T.topo_type_id is NULL,0,T.topo_type_id) WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) WHEN 0 THEN N.label_pas_topo ELSE T.nom END as nom, N.quand AS date FROM niveaux N LEFT JOIN topos T ON N.topo_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 order by date desc limit 1515150
5SHOW FULL COLUMNS FROM `manifestations`12121
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
7SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
8SELECT `Manifestation`.`id`, `Manifestation`.`user_id`, `Manifestation`.`title`, `Manifestation`.`body`, `Manifestation`.`short`, `Manifestation`.`date_debut`, `Manifestation`.`date_fin`, `Manifestation`.`site_web`, `Manifestation`.`created`, `Manifestation`.`modified`, `Manifestation`.`slug`, `Manifestation`.`forum`, `Membre`.`user_id`, `Membre`.`user_regdate`, `Membre`.`username`, `Membre`.`username_clean`, `Membre`.`user_website`, `Membre`.`user_email`, `Membre`.`user_lastvisit`, `Membre`.`user_posts`, `Membre`.`user_avatar` FROM `manifestations` AS `Manifestation` LEFT JOIN `phpbb_users` AS `Membre` ON (`Manifestation`.`user_id` = `Membre`.`user_id`) WHERE `date_debut` >= '2020-09-23' ORDER BY rand() ASC LIMIT 1111
9SELECT `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` = 'manifestation' AND `Image`.`foreign_id` = (292) 110
10SELECT `Manifestation`.`id`, `Manifestation`.`title` FROM `manifestations` AS `Manifestation` WHERE `Manifestation`.`id` = 292 LIMIT 1110
11 SELECT distinct 'Parcours' AS type_icone, 'Photo' AS type , 'Parcours' AS label_icone , T.id AS id, T.slug AS slug, T2.slug AS slug_riviere, TP.numero_ordre AS numero_ordre, concat( T2.nom, ' P', TP.numero_ordre ) AS nom, date(ATT.created) AS date FROM attachments ATT INNER JOIN topos T ON ATT.foreign_id = T.id INNER JOIN topos T2 ON T.parent_id = T2.id INNER JOIN topo_parcours TP ON TP.topo_id = T.id INNER JOIN topo_parcours_details TPD ON TP.id = TPD.topo_parcours_id WHERE T.topo_type_id =4 and ATT.class='Topo' union all SELECT distinct 'Spot' AS type_icone, 'Photo' AS type , 'Spot' AS label_icone , T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, date(ATT.created) AS date FROM attachments ATT INNER JOIN topos T ON ATT.foreign_id = T.id WHERE T.topo_type_id = 2 and ATT.class='Topo' union all SELECT distinct 'Bassin' AS type_icone, 'Photo' AS type , 'Bassin' AS label_icone , T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, date(ATT.created) AS date FROM attachments ATT INNER JOIN topos T ON ATT.foreign_id = T.id WHERE T.topo_type_id = 3 and ATT.class='Topo' ORDER BY date DESC LIMIT 15 15150
12SELECT `Membre`.`user_id`, `Membre`.`user_regdate`, `Membre`.`username`, `Membre`.`username_clean`, `Membre`.`user_website`, `Membre`.`user_email`, `Membre`.`user_lastvisit`, `Membre`.`user_posts`, `Membre`.`user_avatar`, `Profil`.`user_id`, `Profil`.`pf_prenom`, `Profil`.`pf_nom`, `Profil`.`pf_ville`, `Profil`.`pf_bateau`, `Profil`.`pf_pratique`, `Profil`.`pf_region`, `Profil`.`pf_departement`, `Profil`.`pf_club`, `Profil`.`pf_infos_rivieres`, `Profil`.`pf_photo`, `Profil`.`pf_autres_infos` FROM `phpbb_users` AS `Membre` LEFT JOIN `phpbb_profile_fields_data` AS `Profil` ON (`Membre`.`user_id` = `Profil`.`user_id`) WHERE 1 = 1 ORDER BY `user_regdate` DESC LIMIT 15151542
13SELECT `PetiteAnnonce`.`id`, `PetiteAnnonce`.`user_id`, `PetiteAnnonce`.`ip`, `PetiteAnnonce`.`petite_annonce_type_id`, `PetiteAnnonce`.`petite_annonce_matos_type_id`, `PetiteAnnonce`.`contact`, `PetiteAnnonce`.`titre`, `PetiteAnnonce`.`commentaire`, `PetiteAnnonce`.`prix`, `PetiteAnnonce`.`slug`, `PetiteAnnonce`.`created`, `PetiteAnnonce`.`modified` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`user_id` IN (17312, 17311, 17310, 17309, 17308, 17307, 17306, 17305, 17304, 17303, 17302, 17301, 17300, 17299, 17298) 220
14SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`user_id` IN (17312, 17311, 17310, 17309, 17308, 17307, 17306, 17305, 17304, 17303, 17302, 17301, 17300, 17299, 17298) 000
15SELECT `PetiteAnnonce`.`id`, `PetiteAnnonce`.`user_id`, `PetiteAnnonce`.`ip`, `PetiteAnnonce`.`petite_annonce_type_id`, `PetiteAnnonce`.`petite_annonce_matos_type_id`, `PetiteAnnonce`.`contact`, `PetiteAnnonce`.`titre`, `PetiteAnnonce`.`commentaire`, `PetiteAnnonce`.`prix`, `PetiteAnnonce`.`slug`, `PetiteAnnonce`.`created`, `PetiteAnnonce`.`modified`, `Membre`.`user_id`, `Membre`.`username`, `Membre`.`username_clean`, `PetiteAnnonceType`.`id`, `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`action`, `PetiteAnnonceType`.`petite_annonce_categorie_id`, `PetiteAnnonceType`.`slug`, `PetiteAnnonceMatosType`.`id`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`slug` FROM `petite_annonces` AS `PetiteAnnonce` LEFT JOIN `phpbb_users` AS `Membre` ON (`PetiteAnnonce`.`user_id` = `Membre`.`user_id`) LEFT JOIN `petite_annonce_types` AS `PetiteAnnonceType` ON (`PetiteAnnonce`.`petite_annonce_type_id` = `PetiteAnnonceType`.`id`) LEFT JOIN `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` ON (`PetiteAnnonce`.`petite_annonce_matos_type_id` = `PetiteAnnonceMatosType`.`id`) WHERE 1 = 1 ORDER BY `created` DESC LIMIT 1515154
16SELECT `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` = 'PetiteAnnonce' AND `Image`.`foreign_id` IN (15760, 15759, 15758, 15757, 15756, 15755, 15754, 15753, 15751, 15749, 15748, 15747, 15746, 15745, 15744) 18180
17SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15759 LIMIT 1110
18SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15746 LIMIT 1110
19SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15748 LIMIT 1110
20SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15756 LIMIT 1110
21SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15756 LIMIT 1110
22SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15749 LIMIT 1110
23SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15748 LIMIT 1110
24SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15749 LIMIT 1110
25SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15749 LIMIT 1110
26SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15751 LIMIT 1110
27SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15758 LIMIT 1110
28SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15758 LIMIT 1110
29SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15758 LIMIT 1110
30SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15758 LIMIT 1110
31SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15758 LIMIT 1110
32SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15758 LIMIT 1110
33SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15759 LIMIT 1110
34SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15759 LIMIT 1110
35SELECT `PetiteAnnonceCommentaire`.`id`, `PetiteAnnonceCommentaire`.`petite_annonce_id`, `PetiteAnnonceCommentaire`.`auteur_id`, `PetiteAnnonceCommentaire`.`commentaire`, `PetiteAnnonceCommentaire`.`created`, `PetiteAnnonceCommentaire`.`modified` FROM `petite_annonce_commentaires` AS `PetiteAnnonceCommentaire` WHERE `PetiteAnnonceCommentaire`.`petite_annonce_id` IN (15760, 15759, 15758, 15757, 15756, 15755, 15754, 15753, 15751, 15749, 15748, 15747, 15746, 15745, 15744) 000
36SELECT `PetiteAnnonceDiscipline`.`id`, `PetiteAnnonceDiscipline`.`nom`, `PetiteAnnonceDiscipline`.`slug`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`id`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_id`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` JOIN `petite_annonces_petite_annonce_disciplines` AS `PetiteAnnoncesPetiteAnnonceDiscipline` ON (`PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_id` IN (15760, 15759, 15758, 15757, 15756, 15755, 15754, 15753, 15751, 15749, 15748, 15747, 15746, 15745, 15744) AND `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` = `PetiteAnnonceDiscipline`.`id`) 19190
37SELECT AL.annu_lien_name, AL.annu_lien_url , FROM_UNIXTIME(AL.annu_lien_time) as date, AL.annu_lien_cat, AC.annu_cat_name , AC1.annu_cat_name as cat1, AC2.annu_cat_name as cat2, AC3.annu_cat_name as cat3 FROM phpbb_annuaire_liens AL inner join phpbb_annuaire_cats AC on AL.`annu_lien_cat`=AC.`annu_cat_id` left join phpbb_annuaire_cats AC1 on AC.parent_id=AC1.annu_cat_id left join phpbb_annuaire_cats AC2 on AC1.parent_id=AC2.annu_cat_id left join phpbb_annuaire_cats AC3 on AC2.parent_id=AC3.annu_cat_id ORDER BY AL.annu_lien_time desc LIMIT 1515150