FIAF Moving Image Cataloguing Manual Open Forum
Topic: Multi-level hierarchy - advantages?
(Please notify me by email of any new comments added to this discussion.)
74
Member access
Forthcoming events
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 < '2025-05-03 05:49:56' AND p.dDateFinEvent >= '2025-05-03 05:49:56' AND (p.dDateFin >= '2025-05-03 05:49:56' OR p.dDateFin = '0000-00-00 00:00:00')
ORDER BY p.dDateDebutEvent ASC LIMIT 4
News
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 < '2025-05-03 05:49:56' AND (p.dDateFin >= '2025-05-03 05:49:56' OR p.dDateFin = '0000-00-00 00:00:00')
ORDER BY p.dDate DESC LIMIT 4
FIAF is a member of
FIAF is supported by
