almost there...
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start ...' at line 1
query: SELECT n.nid, n.uid, n.title, n.type, e.event_start, e.event_start AS event_start_orig, e.event_end, e.event_end AS event_end_orig, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 0 SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 0 SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL -14400 SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL -14400 SECOND AS event_end_site, tz.name as timezone_name FROM node n INNER JOIN event e ON n.nid = e.nid INNER JOIN event_timezones tz ON tz.timezone = e.timezone WHERE n.status = 1 AND ((e.event_start >= '2012-05-12 00:00:00' AND e.event_start <= '2012-05-21 00:00:00') OR (e.event_end >= '2012-05-12 00:00:00' AND e.event_end <= '2012-05-21 00:00:00') OR (e.event_start <= '2012-05-12 00:00:00' AND e.event_end >= '2012-05-21 00:00:00')) GROUP BY n.nid HAVING (event_start >= '2012-05-13 00:00:00' AND event_start <= '2012-05-20 00:00:00') OR (event_end >= '2012-05-13 00:00:00' AND event_end <= '2012-05-20 00:00:00') OR (event_start <= '2012-05-13 00:00:00' AND event_end >= '2012-05-20 00:00:00') ORDER BY event_start ASC in /var/www/clients/client2/web3/web/modules/event/event_database.mysql.inc on line 104.
back out to the movie room we go, cut the screen out of it's housing and stapled it to the frame, this would be the second most difficult part of the experience because the screen is not really stretchy material so getting the wrinkles out took some "doing"...