Calendar

  • user warning: Unknown column 'node_data_field_deadline.field_datetime_no_to_value' in 'where clause' query: SELECT node.nid AS nid, node.title AS node_title, node_data_field_prints_due.field_prints_due_value AS node_data_field_prints_due_field_prints_due_value, node.type AS node_type, node.vid AS node_vid, node_data_field_prints_hung.field_prints_hung_value AS node_data_field_prints_hung_field_prints_hung_value, node_data_field_prints_removed.field_prints_removed_value AS node_data_field_prints_removed_field_prints_removed_value, node_data_field_deadline.field_deadline_value AS node_data_field_deadline_field_deadline_value, node_data_field_show_opening.field_show_opening_value AS node_data_field_show_opening_field_show_opening_value, node_data_field_show_opening.field_show_opening_value2 AS node_data_field_show_opening_field_show_opening_value2, node_data_field_datetime_no_to.field_datetime_no_to_value AS node_data_field_datetime_no_to_field_datetime_no_to_value, node_data_field_datetime.field_datetime_value AS node_data_field_datetime_field_datetime_value FROM node node LEFT JOIN content_type_competition node_data_field_datetime_no_to ON node.vid = node_data_field_datetime_no_to.vid LEFT JOIN content_type_show node_data_field_show_opening ON node.vid = node_data_field_show_opening.vid LEFT JOIN content_type_show node_data_field_prints_due ON node.vid = node_data_field_prints_due.vid LEFT JOIN content_type_show node_data_field_prints_hung ON node.vid = node_data_field_prints_hung.vid LEFT JOIN content_type_show node_data_field_prints_removed ON node.vid = node_data_field_prints_removed.vid LEFT JOIN content_field_datetime node_data_field_datetime ON node.vid = node_data_field_datetime.vid LEFT JOIN content_field_deadline node_data_field_deadline ON node.vid = node_data_field_deadline.vid WHERE ((node.status <> 0) AND (node.type in ('competition', 'field_trip', 'meeting', 'show'))) AND (((DATE_FORMAT(node_data_field_deadline.field_datetime_no_to_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_datetime_no_to_value, '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(ADDTIME(node_data_field_deadline.field_show_opening_value, SEC_TO_TIME(-14400)), '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(ADDTIME(node_data_field_deadline.field_show_opening_value2, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(node_data_field_deadline.field_prints_due_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_prints_due_value, '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(node_data_field_deadline.field_prints_hung_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_prints_hung_value, '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(node_data_field_deadline.field_prints_removed_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_prints_removed_value, '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(ADDTIME(node_data_field_deadline.field_datetime_value, SEC_TO_TIME(-14400)), '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(ADDTIME(node_data_field_deadline.field_datetime_value2, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(node_data_field_deadline.field_deadline_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_deadline_value, '%Y-%m-%d') >= '2010-07-21'))) ORDER BY node_data_field_datetime_no_to_field_datetime_no_to_value ASC, node_data_field_show_opening_field_show_opening_value ASC, node_data_field_prints_due_field_prints_due_value ASC, node_data_field_prints_hung_field_prints_hung_value ASC, node_data_field_prints_removed_field_prints_removed_value ASC, node_data_field_datetime_field_datetime_value ASC, node_data_field_deadline_field_deadline_value ASC in /home/content/27/4830027/html/sites/all/modules/views/includes/view.inc on line 775.
  • user warning: Unknown column 'node_data_field_deadline.field_datetime_no_to_value' in 'where clause' query: SELECT node.nid AS nid, node.title AS node_title, node_data_field_prints_due.field_prints_due_value AS node_data_field_prints_due_field_prints_due_value, node.type AS node_type, node.vid AS node_vid, node_data_field_prints_hung.field_prints_hung_value AS node_data_field_prints_hung_field_prints_hung_value, node_data_field_prints_removed.field_prints_removed_value AS node_data_field_prints_removed_field_prints_removed_value, node_data_field_deadline.field_deadline_value AS node_data_field_deadline_field_deadline_value, node_data_field_show_opening.field_show_opening_value AS node_data_field_show_opening_field_show_opening_value, node_data_field_show_opening.field_show_opening_value2 AS node_data_field_show_opening_field_show_opening_value2, node_data_field_datetime_no_to.field_datetime_no_to_value AS node_data_field_datetime_no_to_field_datetime_no_to_value, node_data_field_datetime.field_datetime_value AS node_data_field_datetime_field_datetime_value FROM node node LEFT JOIN content_type_competition node_data_field_datetime_no_to ON node.vid = node_data_field_datetime_no_to.vid LEFT JOIN content_type_show node_data_field_show_opening ON node.vid = node_data_field_show_opening.vid LEFT JOIN content_type_show node_data_field_prints_due ON node.vid = node_data_field_prints_due.vid LEFT JOIN content_type_show node_data_field_prints_hung ON node.vid = node_data_field_prints_hung.vid LEFT JOIN content_type_show node_data_field_prints_removed ON node.vid = node_data_field_prints_removed.vid LEFT JOIN content_field_datetime node_data_field_datetime ON node.vid = node_data_field_datetime.vid LEFT JOIN content_field_deadline node_data_field_deadline ON node.vid = node_data_field_deadline.vid WHERE ((node.status <> 0) AND (node.type in ('competition', 'field_trip', 'meeting', 'show'))) AND (((DATE_FORMAT(node_data_field_deadline.field_datetime_no_to_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_datetime_no_to_value, '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(ADDTIME(node_data_field_deadline.field_show_opening_value, SEC_TO_TIME(-14400)), '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(ADDTIME(node_data_field_deadline.field_show_opening_value2, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(node_data_field_deadline.field_prints_due_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_prints_due_value, '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(node_data_field_deadline.field_prints_hung_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_prints_hung_value, '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(node_data_field_deadline.field_prints_removed_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_prints_removed_value, '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(ADDTIME(node_data_field_deadline.field_datetime_value, SEC_TO_TIME(-14400)), '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(ADDTIME(node_data_field_deadline.field_datetime_value2, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2010-07-21')) OR ((DATE_FORMAT(node_data_field_deadline.field_deadline_value, '%Y-%m-%d') <= '2010-07-21' AND DATE_FORMAT(node_data_field_deadline.field_deadline_value, '%Y-%m-%d') >= '2010-07-21'))) ORDER BY node_data_field_datetime_no_to_field_datetime_no_to_value ASC, node_data_field_show_opening_field_show_opening_value ASC, node_data_field_prints_due_field_prints_due_value ASC, node_data_field_prints_hung_field_prints_hung_value ASC, node_data_field_prints_removed_field_prints_removed_value ASC, node_data_field_datetime_field_datetime_value ASC, node_data_field_deadline_field_deadline_value ASC in /home/content/27/4830027/html/sites/all/modules/views/includes/view.inc on line 775.