New Haven
YALE FILM ARCHIVE
Sterling Memorial Library, 120 High Street, New Haven CT 06511, UNITED STATES OF AMERICAT : +1-203 432 0148
F : +1-203 432 4079
filmarchive@yale.edu
http://library.yale.edu/film
Correspondence
| Mr. Brian Meacham | Managing Archivist | +1-203 432 2798 |
Joined FIAF in 2014
Current status : Member
FIAF Affiliation History
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 < '2026-05-06 17:31:21' AND p.dDateFinEvent >= '2026-05-06 17:31:21' AND (p.dDateFin >= '2026-05-06 17:31:21' 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 < '2026-05-06 17:31:21' AND (p.dDateFin >= '2026-05-06 17:31:21' OR p.dDateFin = '0000-00-00 00:00:00')
ORDER BY p.dDate DESC LIMIT 4
FIAF is a member of
NGO in official
partnership with
partnership with
(associate status)
FIAF is supported by
