International Directory of Film-Related Collections

SELECT p.*, c.sTitre, c.sDescription, c.sIntro, c.sIntro2, c.sIntro3, c.nIntroLien, c.nIntro2Lien, c.nIntro3Lien, c.sIntroLien, c.sIntro2Lien, c.sIntro3Lien, c.sContenu, cat.sCategorie, p.sPage FROM t_page as p, t_contenu as c, tref_langue as l, tref_categorie as cat WHERE p.nIdPage = c.nIdPage AND c.nIdLangue = l.nIdLangue AND cat.nIdCategorie = p.nIdCategorie AND l.sCodeLangue = 'en' AND p.nStatut = '1' AND ( p.nEstUnForthcomingEvent ='1' OR cat.sCategorie = 'Forthcoming-Events' ) AND p.dDateDebut < '2026-05-02 18:54:16' AND p.dDateFinEvent >= '2026-05-02 18:54:16' AND (p.dDateFin >= '2026-05-02 18:54:16' OR p.dDateFin = '0000-00-00 00:00:00') ORDER BY p.dDateDebutEvent ASC LIMIT 4

SELECT p.*, c.sTitre, c.sDescription, c.sIntro, c.sIntro2, c.sIntro3, c.nIntroLien, c.nIntro2Lien, c.nIntro3Lien, c.sIntroLien, c.sIntro2Lien, c.sIntro3Lien, c.sContenu, cat.sCategorie, p.sPage FROM t_page as p, t_contenu as c, tref_langue as l, tref_categorie as cat WHERE p.nIdPage = c.nIdPage AND c.nIdLangue = l.nIdLangue AND cat.nIdCategorie = p.nIdCategorie AND l.sCodeLangue = 'en' AND p.nStatut = '1' AND ( p.nEstUneNews ='1' OR cat.sCategorie = 'News' ) AND p.dDateDebut < '2026-05-02 18:54:16' AND (p.dDateFin >= '2026-05-02 18:54:16' OR p.dDateFin = '0000-00-00 00:00:00') ORDER BY p.dDate DESC LIMIT 4