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 (((node_data_field_dateandtime.field_eventdateandtime_value <= '2010-03-22 00:00:00' AND node_data_field_dateandtime.field_eventdateandtime_value2 >= '2010-03-15 00:00:00')) OR ((node_data_field_dateandtime.field_eventdateandtime_value <= '2010-03-22 00:00:00' AND node_data_field_dateandtime.field_eventdateandtime_value2 >= '2010-03-15 00:00:00')) OR ((node_data_field_dateandtime.field_dateandtime_value <= '2010-03-22 00:00:00' AND node_data_field_dateandtime.field_dateandtime_value2 >= '2010-03-15 00:00:00')))
)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.
]