SQL: SELECT f_title,f_id,f_director from f_display where f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^0'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^1'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^2'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^3'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^4'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^5'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^6'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^7'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^8'
OR f_year='2005' and f_category NOT REGEXP 'Panel' AND f_category NOT REGEXP 'concert' AND f_title REGEXP '^9'
GROUP BY f_title ORDER BY f_title
The Woodstock Film Festival is a not-for-profit, 501 (C)(3) organization with a mission to present an
annual program and year-round schedule of film, music,
and art-related activities that promote artists, culture,
inspired learning, and diversity. The Hudson Valley Film
Commission promotes sustainable economic development
by attracting and supporting film, video and media production.
Copyright, 2000-2010 Woodstock
Film Festival, Inc., a not-for profit organization