| 1 |
SELECT Topics.topic_id, Topics.topic_title, Forums.forum_name, Topics.topic_last_post_time, Topics.topic_last_post_id
FROM phpbb_topics Topics
INNER JOIN phpbb_forums Forums on Topics.forum_id = Forums.forum_id
WHERE 1=1
ORDER BY Topics.topic_last_post_time DESC
limit 15 | | 15 | 15 | 1 |
| 2 | SELECT DISTINCT
-- Tutu
CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 1 THEN 'Riviere' END AS type_icone,
'topos' AS type ,
CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 1 THEN 'Riviere' END AS label_icone ,
TF.id AS id,
TF.id as topo_id,
TF.slug AS slug,
CASE TF.topo_type_id WHEN 4 THEN TF2.slug ELSE null END AS slug_riviere,
CASE TF.topo_type_id WHEN 4 THEN TF.numero_ordre ELSE null END AS numero_ordre,
CASE TF.topo_type_id WHEN 4 THEN concat( TF2.nom, ' P', TF.numero_ordre ) ELSE TF.nom END AS nom_parcours,
TF.nom as nom,
TF.modified AS date,
TF.user_id,
U.username,
U.user_avatar,
TF.user_2_id,
U2.username as username2 ,
TF.cotation as text,
CAF.departement_code,
CAF.departement_nom,
CAF.region_id,
CAF.region_nom,
CAF.pays_id,
CAF.pays_nom
FROM topos_facility TF
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN phpbb_users U ON TF.user_id=U.user_id
LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id
-- Coordonnées administratives
INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id
INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id
WHERE TF.etat = 0
union all
SELECT DISTINCT
CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 1 THEN 'Riviere' END AS type_icone,
'topo_commentaires' AS type ,
'Commentaire' AS label_icone,
TF.id AS id,
TF.id as topo_id,
TF.slug AS slug,
CASE TF.topo_type_id WHEN 4 THEN TF2.slug ELSE TF.slug END AS slug_riviere,
CASE TF.topo_type_id WHEN 4 THEN TF.numero_ordre ELSE 0 END AS numero_ordre,
CASE TF.topo_type_id WHEN 4 THEN concat( TF2.nom, ' P', TF.numero_ordre ) ELSE TF.nom END AS nom_parcours,
TF.nom as nom,
TC.created AS date,
TC.user_id,
U.username,
U.user_avatar,
TF.user_2_id,
U2.username as username2 ,
TC.commentaire as text,
CAF.departement_code,
CAF.departement_nom,
CAF.region_id,
CAF.region_nom,
CAF.pays_id,
CAF.pays_nom
FROM topo_commentaires TC
INNER JOIN topos_facility TF ON TC.topo_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN phpbb_users U ON TC.user_id=U.user_id
LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id
-- Coordonnées administratives
INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id
INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id
WHERE TF.etat = 0
union all
SELECT DISTINCT
'Carto' AS type_icone,
'Carto' AS type ,
'Carto' AS label_icone,
CC.id AS id,
TF.id as topo_id,
TF.slug AS slug,
TF.slug AS slug_riviere,
0 AS numero_ordre,
CASE TF.topo_type_id WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) ELSE TF.nom END as nom_parcours,
TF.nom as nom,
CC.created AS date,
CC.user_id as user_id,
U.username,
U.user_avatar,
null as user_id_2,
null as username2 ,
null as text,
CAF.departement_code,
CAF.departement_nom,
CAF.region_id,
CAF.region_nom,
CAF.pays_id,
CAF.pays_nom
FROM `carto_coordonnees` CC
INNER JOIN carto_types CT on CC.carto_type_id=CT.id
INNER JOIN topos_facility TF ON CC.objet_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN phpbb_users U ON TF.user_id=U.user_id
LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id
-- Coordonnées administratives
INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id
INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id
GROUP BY CC.objet_id
union all
SELECT DISTINCT
'RefNiveau' AS type_icone,
'RefNiveau' AS type ,
'Niveau calibrage' AS label_icone,
RN.id AS id,
TF.id as topo_id,
TF.slug AS slug,
TF.slug AS slug_riviere,
TF.numero_ordre AS numero_ordre,
CASE TF.topo_type_id WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) ELSE TF.nom END as nom_parcours,
TF.nom as nom,
RN.modified AS date,
TF.user_id,
U.username,
U.user_avatar,
TF.user_2_id,
U2.username as username2 ,
IF (RN.min IS NOT NULL,IF (RN.max IS NOT NULL,concat( concat("Min:",RN.min), concat(" - Max:",RN.max)), concat("Min:",RN.min)),null) as text,
CAF.departement_code,
CAF.departement_nom,
CAF.region_id,
CAF.region_nom,
CAF.pays_id,
CAF.pays_nom
FROM `niveau_references_de_niveaux` RN
INNER JOIN topos_facility TF ON RN.topo_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN phpbb_users U ON TF.user_id=U.user_id
LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id
-- Coordonnées administratives
INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id
INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id
ORDER BY date desc
LIMIT 10 | | 10 | 10 | 1080 |
| 3 | SELECT id,parent_id,topo_type_id from topos_facility where id=2260; | | 1 | 1 | 0 |
| 4 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=2260
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 5 | SELECT id,parent_id,topo_type_id from topos_facility where id=3055; | | 1 | 1 | 0 |
| 6 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=3055
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 1 |
| 7 | SELECT
'Parcours' AS type_icone ,
'dernieres_descentes' AS type ,
'Dernière descente' AS label_icone ,
DD.id AS id,
TF.id as topo_id,
TF.slug AS slug,
TF2.slug as slug_riviere,
TF.numero_ordre as numero_ordre,
CASE TF.topo_type_id WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) ELSE TF.nom END as nom_parcours,
TF.nom AS nom,
DD.quand AS date,
TF.user_id,
U.username,
U.user_avatar,
TF.user_2_id,
U2.username as username2 ,
DD.commentaire as text,
null as text2,
CAF.departement_code,
CAF.departement_nom,
CAF.region_id,
CAF.region_nom,
CAF.pays_id,
CAF.pays_nom
FROM dernieres_descentes DD
INNER JOIN topos_facility TF ON DD.topo_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN phpbb_users U ON DD.user_id=U.user_id
LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id
-- Coordonnées administratives
INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id
INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id
WHERE
TF.topo_type_id=4
union all
SELECT distinct
CASE IF(TF.topo_type_id is NULL,0,TF.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 ,
'Relevé de niveau' as label_icone,
N.id AS id,
TF.id as topo_id,
TF.slug AS slug,
TF.slug AS slug_riviere,
0 AS numero_ordre,
CASE TF.topo_type_id WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre) ELSE TF.nom END as nom_parcours,
CASE IF(TF.topo_type_id is NULL,0,TF.topo_type_id)
WHEN 4 THEN concat(TF2.nom," P",TF.numero_ordre)
WHEN 0 THEN N.label_pas_topo
ELSE TF.nom END as nom,
N.quand AS date,
TF.user_id,
U.username,
U.user_avatar,
TF.user_2_id,
U2.username as username2 ,
concat (
concat ("Evaluation : ",NE.name," - "),
IF (N.valeur IS NOT NULL,
IF (N.unite IS NOT NULL,
concat( N.valeur , concat(" ",N.unite)),
N.valeur
)
,null)
) as text,
N.commentaire as text2,
CAF.departement_code,
CAF.departement_nom,
CAF.region_id,
CAF.region_nom,
CAF.pays_id,
CAF.pays_nom
FROM niveaux N
INNER JOIN niveau_evaluations NE on NE.id=N.niveau_evaluation_id
LEFT JOIN topos_facility TF ON N.topo_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN phpbb_users U ON N.user_id=U.user_id
LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id
-- Coordonnées administratives
INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id
INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id
order by date desc
limit 15 | | 15 | 15 | 140 |
| 8 | SELECT id,parent_id,topo_type_id from topos_facility where id=295; | | 1 | 1 | 0 |
| 9 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.parent_id=295
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 10 | SELECT id,parent_id,topo_type_id from topos_facility where id=1099; | | 1 | 1 | 0 |
| 11 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=1099
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 12 | SELECT id,parent_id,topo_type_id from topos_facility where id=1968; | | 1 | 1 | 0 |
| 13 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=1968
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 1 |
| 14 | SELECT id,parent_id,topo_type_id from topos_facility where id=1597; | | 1 | 1 | 0 |
| 15 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=1597
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 16 | SELECT id,parent_id,topo_type_id from topos_facility where id=21; | | 1 | 1 | 0 |
| 17 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.parent_id=21
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 18 | SELECT id,parent_id,topo_type_id from topos_facility where id=1491; | | 1 | 1 | 0 |
| 19 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=1491
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 20 | SELECT id,parent_id,topo_type_id from topos_facility where id=1493; | | 1 | 1 | 0 |
| 21 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=1493
ORDER BY rand() ASC LIMIT 1 | | 0 | 0 | 1 |
| 22 | SELECT id,parent_id,topo_type_id from topos_facility where id=871; | | 1 | 1 | 0 |
| 23 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=871
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 24 | SELECT id,parent_id,topo_type_id from topos_facility where id=939; | | 1 | 1 | 0 |
| 25 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=939
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 26 | SELECT id,parent_id,topo_type_id from topos_facility where id=1078; | | 1 | 1 | 0 |
| 27 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=1078
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 28 | SELECT id,parent_id,topo_type_id from topos_facility where id=805; | | 1 | 1 | 0 |
| 29 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=805
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 30 | SELECT id,parent_id,topo_type_id from topos_facility where id=1179; | | 1 | 1 | 0 |
| 31 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=1179
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 32 | SELECT id,parent_id,topo_type_id from topos_facility where id=1029; | | 1 | 1 | 0 |
| 33 | SELECT
-- tata
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.id
WHERE Image.`mimetype` LIKE 'image%'
AND Image.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND Image.peut_illustrer=1
AND TF.id=1029
ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 34 | SHOW FULL COLUMNS FROM `manifestations` | | 12 | 12 | 2 |
| 35 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
| 36 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin'; | | 1 | 1 | 1 |
| 37 | 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_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_fin` >= '2023-09-22' ORDER BY rand() ASC LIMIT 1 | | 1 | 1 | 2 |
| 38 | 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` = (327) | | 1 | 1 | 10 |
| 39 | SELECT `Manifestation`.`id`, `Manifestation`.`title` FROM `manifestations` AS `Manifestation` WHERE `Manifestation`.`id` = 327 LIMIT 1 | | 1 | 1 | 0 |
| 40 | SELECT distinct
CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' END AS type_icone,
'Photo' AS type,
CASE TF.topo_type_id WHEN 4 THEN 'Parcours' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' END AS label_icone ,
TF.id AS id,
TF.id as topo_id,
TF.slug AS slug,
CASE TF.topo_type_id WHEN 4 THEN TF2.slug ELSE null END AS slug_riviere,
CASE TF.topo_type_id WHEN 4 THEN TF.numero_ordre ELSE null END AS numero_ordre,
CASE TF.topo_type_id WHEN 4 THEN concat( TF2.nom, ' P', TF.numero_ordre ) ELSE TF.nom END AS nom_parcours,
TF.nom as nom,
TF.modified AS date,
TF.user_id,
CASE TF.topo_type_id WHEN 4 THEN concat( TF2.nom, ' P', TF.numero_ordre ) ELSE TF.nom END AS nom,
U.username,
U.user_id,
CAF.departement_code,
CAF.departement_nom,
CAF.region_id,
CAF.region_nom,
CAF.pays_id,
CAF.pays_nom,
date_format(ATT.created,'%Y-%m-%d') as date
FROM attachments ATT
-- Toto
-- Topos
INNER JOIN topos_facility TF ON ATT.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
-- Coordonnées administratives
INNER JOIN coordonnee_administrative_topos CAT ON CAT.topo_id=TF.id
INNER JOIN coordonnees_administratives_facility CAF ON CAT.coordonnees_administrative_id=CAF.id
-- Users
INNER JOIN phpbb_users U ON ATT.user_id=U.user_id
LEFT JOIN phpbb_users U2 ON TF.user_2_id=U2.user_id
WHERE ATT.class='Topo' and TF.topo_type_id in (4,2,3)
ORDER BY ATT.created DESC
LIMIT 15 | | 15 | 15 | 505 |
| 41 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3055
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3055
and date_format(ATT.created,'%Y-%m-%d')= '2023-09-21'
)
ORDER BY RAND() ASC
LIMIT 15 | | 1 | 1 | 2 |
| 42 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3055
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3055
and date_format(ATT.created,'%Y-%m-%d')= '2023-05-16'
)
ORDER BY RAND() ASC
LIMIT 15 | | 1 | 1 | 2 |
| 43 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 1285
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 1285
and date_format(ATT.created,'%Y-%m-%d')= '2023-05-05'
)
ORDER BY RAND() ASC
LIMIT 15 | | 1 | 1 | 2 |
| 44 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3053
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3053
and date_format(ATT.created,'%Y-%m-%d')= '2023-04-22'
)
ORDER BY RAND() ASC
LIMIT 15 | | 6 | 6 | 2 |
| 45 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3051
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3051
and date_format(ATT.created,'%Y-%m-%d')= '2023-04-22'
)
ORDER BY RAND() ASC
LIMIT 15 | | 8 | 8 | 2 |
| 46 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3047
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3047
and date_format(ATT.created,'%Y-%m-%d')= '2023-03-30'
)
ORDER BY RAND() ASC
LIMIT 15 | | 3 | 3 | 2 |
| 47 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 1461
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 1461
and date_format(ATT.created,'%Y-%m-%d')= '2023-03-29'
)
ORDER BY RAND() ASC
LIMIT 15 | | 7 | 7 | 2 |
| 48 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2920
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2920
and date_format(ATT.created,'%Y-%m-%d')= '2023-03-22'
)
ORDER BY RAND() ASC
LIMIT 15 | | 2 | 2 | 2 |
| 49 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 929
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 929
and date_format(ATT.created,'%Y-%m-%d')= '2023-03-19'
)
ORDER BY RAND() ASC
LIMIT 15 | | 12 | 12 | 2 |
| 50 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2920
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2920
and date_format(ATT.created,'%Y-%m-%d')= '2023-03-19'
)
ORDER BY RAND() ASC
LIMIT 15 | | 1 | 1 | 2 |
| 51 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2915
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2915
and date_format(ATT.created,'%Y-%m-%d')= '2023-02-12'
)
ORDER BY RAND() ASC
LIMIT 15 | | 2 | 2 | 2 |
| 52 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3042
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 3042
and date_format(ATT.created,'%Y-%m-%d')= '2023-01-14'
)
ORDER BY RAND() ASC
LIMIT 15 | | 7 | 7 | 2 |
| 53 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2702
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2702
and date_format(ATT.created,'%Y-%m-%d')= '2022-12-23'
)
ORDER BY RAND() ASC
LIMIT 15 | | 5 | 5 | 2 |
| 54 | SELECT
-- tata
ATT.*
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2083
AND DATE(ATT.created) =(
SELECT
MAX(DATE(ATT.created)) AS DATE
FROM
`attachments` AS ATT
INNER JOIN attachments_links AL ON ATT.id = AL.attachment_id
INNER JOIN topos_facility TF ON AL.foreign_id = TF.id
WHERE
ATT.`mimetype` LIKE 'image%'
AND ATT.`class` = 'Topo'
AND AL.`class` = 'Topo'
AND ATT.peut_illustrer = 1
AND TF.id = 2083
and date_format(ATT.created,'%Y-%m-%d')= '2022-12-18'
)
ORDER BY RAND() ASC
LIMIT 15 | | 1 | 1 | 2 |
| 55 | SELECT
TT.nom,
TF.slug,
TF.nom,
TF2.slug,
TF2.nom,
TF.id,
TF.numero_ordre,
TF.topo_type_id,
Image.*
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
-- 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
INNER JOIN topos_facility TF ON AL.foreign_id=TF.id
LEFT JOIN topos TF2 ON TF.parent_id=TF2.id
INNER JOIN topo_types TT on TF.topo_type_id=TT.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 | 275 |
| 56 | SELECT `Membre`.`user_id`, `Membre`.`user_regdate`, `Membre`.`username`, `Membre`.`username_clean`, `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`, `Profil`.`pf_phpbb_interests`, `Profil`.`pf_phpbb_occupation`, `Profil`.`pf_phpbb_icq`, `Profil`.`pf_phpbb_website`, `Profil`.`pf_phpbb_yahoo`, `Profil`.`pf_phpbb_aol`, `Profil`.`pf_phpbb_location`, `Profil`.`pf_phpbb_facebook`, `Profil`.`pf_phpbb_googleplus`, `Profil`.`pf_phpbb_skype`, `Profil`.`pf_phpbb_twitter`, `Profil`.`pf_phpbb_youtube` 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 | 37 |
| 57 | 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`, `Membre`.`user_avatar`, `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 `modified` DESC LIMIT 10 | | 10 | 10 | 3 |
| 58 | 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 (16310, 16311, 16306, 16309, 16308, 16307, 16305, 16304, 16303, 16302) | | 8 | 8 | 12 |
| 59 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16302 LIMIT 1 | | 1 | 1 | 0 |
| 60 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16302 LIMIT 1 | | 1 | 1 | 0 |
| 61 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16306 LIMIT 1 | | 1 | 1 | 0 |
| 62 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16309 LIMIT 1 | | 1 | 1 | 0 |
| 63 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16309 LIMIT 1 | | 1 | 1 | 0 |
| 64 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16310 LIMIT 1 | | 1 | 1 | 0 |
| 65 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16311 LIMIT 1 | | 1 | 1 | 0 |
| 66 | SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 16310 LIMIT 1 | | 1 | 1 | 0 |
| 67 | 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 (16310, 16311, 16306, 16309, 16308, 16307, 16305, 16304, 16303, 16302) | | 0 | 0 | 0 |
| 68 | 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 (16310, 16311, 16306, 16309, 16308, 16307, 16305, 16304, 16303, 16302) AND `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` = `PetiteAnnonceDiscipline`.`id`) | | 10 | 10 | 1 |
| 69 | SELECT `AnnuaireLien`.`id`, `AnnuaireLien`.`annu_lien_time`, `AnnuaireLien`.`annu_lien_url`, `AnnuaireLien`.`annu_lien_description`, `AnnuaireLien`.`annu_lien_active`, `AnnuaireLien`.`annuaire_cat_id`, `AnnuaireLien`.`user_id`, `AnnuaireLien`.`name`, `AnnuaireLien`.`annu_lien_thumb`, `AnnuaireLien`.`coordonnees_administrative_id`, `AnnuaireLien`.`annu_lien_backlink`, `AnnuaireLien`.`created`, `AnnuaireLien`.`updated`, `AnnuaireCat`.`id`, `AnnuaireCat`.`parent_id`, `AnnuaireCat`.`lft`, `AnnuaireCat`.`rght`, `AnnuaireCat`.`annu_cat_parents`, `AnnuaireCat`.`name`, `AnnuaireCat`.`annu_cat_desc`, `AnnuaireCat`.`annu_cat_links`, `AnnuaireCat`.`annu_cat_icon`, `AnnuaireCat`.`annu_cat_desc_bitfield`, `AnnuaireCat`.`annu_cat_desc_options`, `AnnuaireCat`.`annu_cat_desc_uid`, `AnnuaireCat`.`annu_display_subcat_list`, `AnnuaireCat`.`annu_cat_allow_comments`, `AnnuaireCat`.`annu_cat_allow_votes`, `AnnuaireCat`.`annu_cat_must_describe`, `AnnuaireCat`.`annu_cat_link_back`, `AnnuaireCat`.`annu_cat_cron_enable`, `AnnuaireCat`.`annu_cat_cron_next`, `AnnuaireCat`.`annu_cat_cron_freq`, `AnnuaireCat`.`annu_cat_cron_nb_check`, `PhpbbUser`.`user_id`, `PhpbbUser`.`username`, `CoordonneesAdministrative`.`id`, `CoordonneesAdministrative`.`nom`, `CoordonneesAdministrative`.`slug`, `CoordonneesAdministrative`.`code`, `CoordonneesAdministrative`.`coordonnee_administrative_type_id`, `CoordonneesAdministrative`.`parent_id`, `CoordonneesAdministrative`.`lft`, `CoordonneesAdministrative`.`rght`, `CoordonneesAdministrative`.`Migration` FROM `annuaire_liens` AS `AnnuaireLien` LEFT JOIN `annuaire_cats` AS `AnnuaireCat` ON (`AnnuaireLien`.`annuaire_cat_id` = `AnnuaireCat`.`id`) LEFT JOIN `phpbb_users` AS `PhpbbUser` ON (`AnnuaireLien`.`user_id` = `PhpbbUser`.`user_id`) LEFT JOIN `coordonnees_administratives` AS `CoordonneesAdministrative` ON (`AnnuaireLien`.`coordonnees_administrative_id` = `CoordonneesAdministrative`.`id`) WHERE 1 = 1 ORDER BY `created` DESC LIMIT 15 | | 15 | 15 | 2 |
