1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT SQL_CALC_FOUND_ROWS e.idevent AS id_event, e.artiste AS artiste,
e.titreevent AS titre_event, e.datedebutevent AS debut,
e.datefinevent AS fin, e.horaireevent AS horaire ,ruba.id_rubrique AS id_rubrique, ruba.nom_rubrique AS rubrique,
(SELECT rubb.nom_rubrique FROM rubriques_v2 rubb WHERE rubb.bg < rube.bg AND rubb.bd > rube.bd AND rubb.niveau = rube.niveau-1) as categorie,
(SELECT rubc.nom_rubrique FROM rubriques_v2 rubc WHERE rubc.bg < ruba.bg AND rubc.bd > ruba.bd AND rubc.niveau = 0) as section,
l.nomlieu AS lieu, cp.cp_ville AS ville, dep.codedepartement AS id_departement, dep.nomdepartement AS departement , reg.nomregion AS region, reg.idregion AS id_region, pays.nompays AS pays, img.nomimage AS image, img.urlimg AS url, img.urlimgvignette AS thumb, img.credit AS credit_image, img.idimg AS id_image, l.idlieu AS id_lieu, cp.idville AS id_ville, dep.codedepartement as id_departement FROM evenements e
LEFT JOIN lieux l ON l.idlieu = e.idlieu
LEFT JOIN codpostal cp ON l.idville = cp.idville
LEFT JOIN region reg ON cp.idregion = reg.idregion
LEFT JOIN departement dep ON dep.codedepartement = cp.iddept
LEFT JOIN pays pays ON pays.idpays = cp.cp_pays
LEFT JOIN imguser img ON img.idimg = e.urlimg
LEFT JOIN rubriques_v2 ruba ON e.idrubrique = ruba.id_rubrique
LEFT JOIN rubriques_v2 rube ON e.idrubrique = rube.id_rubrique
WHERE
(SELECT rubc.nom_rubrique FROM rubriques_v2 rubc WHERE rubc.bg < ruba.bg AND rubc.bd > ruba.bd AND rubc.niveau = 0) = 'Ma rubrique'
LIMIT 0,2000 |
Partager