user warning: Incorrect information in file: './glenco_db3/node.frm'
query: SELECT DISTINCT(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 7200 SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 7200 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 INNER JOIN node_access na ON na.nid = n.nid WHERE ((n.moderate != 1)) AND (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'image_gallery_access'))) AND ( n.status = 1 AND ((e.event_start >= '2010-08-31 00:00:00' AND e.event_start <= '2010-10-01 23:59:59') OR (e.event_end >= '2010-08-31 00:00:00' AND e.event_end <= '2010-10-01 23:59:59') OR (e.event_start <= '2010-08-31 00:00:00' AND e.event_end >= '2010-10-01 23:59:59')) ) GROUP BY n.nid HAVING (event_start >= '2010-09-01 00:00:00' AND event_start <= '2010-09-30 23:59:59') OR (event_end >= '2010-09-01 00:00:00' AND event_end <= '2010-09-30 23:59:59') OR (event_start <= '2010-09-01 00:00:00' AND event_end >= '2010-09-30 23:59:59') ORDER BY event_start ASC in /usr/www/users/glenco/includes/database.mysql.inc on line 172.
user warning: Incorrect information in file: './glenco_db3/node.frm'
query: SELECT DISTINCT(node.nid), rand() AS random_sort, ad_image.aid AS ad_image_aid FROM node node LEFT JOIN ads ads ON node.nid = ads.aid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN ad_image ad_image ON ads.aid = ad_image.aid LEFT JOIN node n ON node.nid = n.nid INNER JOIN node_access na ON na.nid = node.nid WHERE ((n.moderate != 1)) AND (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'image_gallery_access'))) AND ( (node.type IN ('ad')) AND (ads.adstatus IN ('active')) AND (ads.adtype IN ('image')) AND (term_node.tid IN ('136')) ) ORDER BY random_sort ASC LIMIT 0, 3 in /usr/www/users/glenco/includes/database.mysql.inc on line 172.