Officers 2007-2009

user warning: Unknown column 'node_data_field_dateandtime.field_eventdateandtime_value' in 'where clause' query: SELECT DISTINCT node.nid AS nid, node.changed AS node_changed, node_data_field_eventdateandtime.field_eventdateandtime_value AS node_data_field_eventdateandtime_field_eventdateandtime_value, node_data_field_eventdateandtime.field_eventdateandtime_value2 AS node_data_field_eventdateandtime_field_eventdateandtime_value2, node_data_field_dateandtime.field_dateandtime_value AS node_data_field_dateandtime_field_dateandtime_value FROM drupal_node node LEFT JOIN drupal_content_type_event node_data_field_eventdateandtime ON node.vid = node_data_field_eventdateandtime.vid LEFT JOIN drupal_content_type_event node_data_field_eventdateandtime2 ON node.vid = node_data_field_eventdateandtime2.vid LEFT JOIN drupal_content_field_dateandtime node_data_field_dateandtime ON node.vid = node_data_field_dateandtime.vid INNER JOIN drupal_node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.type in ('cfp', 'event')) AND (((DATE_FORMAT(node_data_field_dateandtime.field_eventdateandtime_value, '%Y-%m-%d') <= '2010-03-23' AND DATE_FORMAT(node_data_field_dateandtime.field_eventdateandtime_value2, '%Y-%m-%d') >= '2010-03-23')) OR ((DATE_FORMAT(node_data_field_dateandtime.field_eventdateandtime_value, '%Y-%m-%d') <= '2010-03-23' AND DATE_FORMAT(node_data_field_dateandtime.field_eventdateandtime_value2, '%Y-%m-%d') >= '2010-03-23')) OR ((DATE_FORMAT(node_data_field_dateandtime.field_dateandtime_value, '%Y-%m-%d') <= '2010-03-23' AND DATE_FORMAT(node_data_field_dateandtime.field_dateandtime_value2, '%Y-%m-%d') >= '2010-03-23'))) )ORDER BY node_changed ASC, node_data_field_eventdateandtime_field_eventdateandtime_value ASC, node_data_field_eventdateandtime_field_eventdateandtime_value2 ASC, node_data_field_dateandtime_field_dateandtime_value ASC in /homepages/18/d286209714/htdocs/cms/modules/views/includes/view.inc on line 775.