| 1 | SHOW FULL COLUMNS FROM `phpbb_users` | | 76 | 76 | 3 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin'; | | 1 | 1 | 1 |
| 3 | SHOW FULL COLUMNS FROM `phpbb_profile_fields_data` | | 12 | 12 | 1 |
| 4 | SHOW FULL COLUMNS FROM `clubs_ffck` | | 15 | 15 | 1 |
| 5 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
| 6 | SHOW FULL COLUMNS FROM `petite_annonces` | | 12 | 12 | 1 |
| 7 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci'; | | 1 | 1 | 1 |
| 8 | SHOW FULL COLUMNS FROM `petite_annonce_types` | | 5 | 5 | 1 |
| 9 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 1 |
| 10 | SHOW FULL COLUMNS FROM `petite_annonce_categories` | | 2 | 2 | 1 |
| 11 | SHOW FULL COLUMNS FROM `petite_annonce_matos_types` | | 3 | 3 | 1 |
| 12 | SHOW FULL COLUMNS FROM `attachments` | | 19 | 19 | 1 |
| 13 | SHOW FULL COLUMNS FROM `attachments_links` | | 6 | 6 | 1 |
| 14 | SHOW FULL COLUMNS FROM `petite_annonce_commentaires` | | 6 | 6 | 1 |
| 15 | SHOW FULL COLUMNS FROM `petite_annonce_disciplines` | | 3 | 3 | 1 |
| 16 | SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines` | | 3 | 3 | 1 |
| 17 | SHOW FULL COLUMNS FROM `niveau_alertes` | | 5 | 5 | 1 |
| 18 | SHOW FULL COLUMNS FROM `topos` | | 10 | 10 | 1 |
| 19 | SHOW FULL COLUMNS FROM `topo_types` | | 2 | 2 | 1 |
| 20 | SHOW FULL COLUMNS FROM `topo_bassins` | | 2 | 2 | 1 |
| 21 | SHOW FULL COLUMNS FROM `topo_bassin_details` | | 21 | 21 | 1 |
| 22 | SHOW FULL COLUMNS FROM `topo_parcours` | | 4 | 4 | 1 |
| 23 | SHOW FULL COLUMNS FROM `topo_parcours_details` | | 25 | 25 | 2 |
| 24 | SHOW FULL COLUMNS FROM `topo_rivieres` | | 2 | 2 | 1 |
| 25 | SHOW FULL COLUMNS FROM `topo_riviere_details` | | 35 | 35 | 2 |
| 26 | SHOW FULL COLUMNS FROM `topo_spots` | | 2 | 2 | 1 |
| 27 | SHOW FULL COLUMNS FROM `topo_spot_details` | | 20 | 20 | 1 |
| 28 | SHOW FULL COLUMNS FROM `niveau_references_de_niveaux` | | 11 | 11 | 1 |
| 29 | SHOW FULL COLUMNS FROM `niveau_stations_de_mesures` | | 10 | 10 | 1 |
| 30 | SHOW FULL COLUMNS FROM `niveau_source_donnees` | | 6 | 6 | 1 |
| 31 | SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels` | | 12 | 12 | 1 |
| 32 | SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types` | | 2 | 2 | 1 |
| 33 | SHOW FULL COLUMNS FROM `niveaux` | | 12 | 12 | 1 |
| 34 | SHOW FULL COLUMNS FROM `niveau_evaluations` | | 3 | 3 | 1 |
| 35 | SHOW FULL COLUMNS FROM `coordonnee_administrative_topos` | | 3 | 3 | 1 |
| 36 | SHOW FULL COLUMNS FROM `coordonnees_administratives` | | 9 | 9 | 1 |
| 37 | SHOW FULL COLUMNS FROM `coordonnee_administrative_types` | | 2 | 2 | 1 |
| 38 |
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,"28")
ORDER BY Topics.topic_last_post_time DESC
limit 15 | | 15 | 15 | 1 |
| 39 | SELECT *
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 1 | | 1 | 1 | 408 |
| 40 | SELECT '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 15 | | 15 | 15 | 0 |
| 41 | SELECT
'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 15 | | 15 | 15 | 0 |
| 42 | SHOW FULL COLUMNS FROM `manifestations` | | 12 | 12 | 2 |
| 43 | SELECT `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` >= '2019-06-20' ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 1 |
| 44 | SELECT `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` = (282) | | 1 | 1 | 0 |
| 45 | SELECT `Manifestation`.`id`, `Manifestation`.`title` FROM `manifestations` AS `Manifestation` WHERE `Manifestation`.`id` = 282 LIMIT 1 | | 1 | 1 | 0 |
| 46 | 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 | | 15 | 15 | 1 |
| 47 | SELECT `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 15 | | 15 | 15 | 41 |
| 48 | SELECT `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 (17181, 17180, 17179, 17178, 17177, 17176, 17175, 17174, 17173, 17172, 17171, 17170, 17169, 17168, 17167) | | 7 | 7 | 0 |
| 49 | SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`user_id` IN (17181, 17180, 17179, 17178, 17177, 17176, 17175, 17174, 17173, 17172, 17171, 17170, 17169, 17168, 17167) | | 0 | 0 | 0 |
| 50 | SELECT `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 15 | | 15 | 15 | 3 |
| 51 | SELECT `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 (15424, 15423, 15422, 15421, 15420, 15419, 15418, 15417, 15416, 15415, 15414, 15413, 15412, 15411, 15410) | | 12 | 12 | 0 |
| 52 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15410 LIMIT 1 | | 1 | 1 | 0 |
| 53 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15410 LIMIT 1 | | 1 | 1 | 0 |
| 54 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15422 LIMIT 1 | | 1 | 1 | 0 |
| 55 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15421 LIMIT 1 | | 1 | 1 | 0 |
| 56 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15421 LIMIT 1 | | 1 | 1 | 0 |
| 57 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15422 LIMIT 1 | | 1 | 1 | 0 |
| 58 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15422 LIMIT 1 | | 1 | 1 | 0 |
| 59 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15421 LIMIT 1 | | 1 | 1 | 0 |
| 60 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15412 LIMIT 1 | | 1 | 1 | 0 |
| 61 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15424 LIMIT 1 | | 1 | 1 | 0 |
| 62 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15424 LIMIT 1 | | 1 | 1 | 0 |
| 63 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15424 LIMIT 1 | | 1 | 1 | 0 |
| 64 | SELECT `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 (15424, 15423, 15422, 15421, 15420, 15419, 15418, 15417, 15416, 15415, 15414, 15413, 15412, 15411, 15410) | | 0 | 0 | 0 |
| 65 | SELECT `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 (15424, 15423, 15422, 15421, 15420, 15419, 15418, 15417, 15416, 15415, 15414, 15413, 15412, 15411, 15410) AND `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` = `PetiteAnnonceDiscipline`.`id`) | | 35 | 35 | 0 |
| 66 | SELECT
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 15 | | 15 | 15 | 1 |
.png)
Commentaire - Roya
Niveau calibrage - Cinqueta P1
Défi du Saumon
