FIAF Moving Image Cataloguing Manual Open Forum
Topic: Add examples showing different ways of linking or representing Item "components", with an emphasis on digital scenarios.
(Please notify me by email of any new comments added to this discussion.)
68
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 04:59:16' AND p.dDateFinEvent >= '2025-05-03 04:59:16' AND (p.dDateFin >= '2025-05-03 04:59:16' 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 04:59:16' AND (p.dDateFin >= '2025-05-03 04:59:16' 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
