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 (((node_data_field_deadline.field_datetime_no_to_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_datetime_no_to_value >= '2010-06-27 00:00:00')) OR ((ADDTIME(node_data_field_deadline.field_show_opening_value, SEC_TO_TIME(-14400)) <= '2010-07-04 00:00:00' AND ADDTIME(node_data_field_deadline.field_show_opening_value2, SEC_TO_TIME(-14400)) >= '2010-06-27 00:00:00')) OR ((node_data_field_deadline.field_prints_due_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_prints_due_value >= '2010-06-27 00:00:00')) OR ((node_data_field_deadline.field_prints_hung_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_prints_hung_value >= '2010-06-27 00:00:00')) OR ((node_data_field_deadline.field_prints_removed_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_prints_removed_value >= '2010-06-27 00:00:00')) OR ((ADDTIME(node_data_field_deadline.field_datetime_value, SEC_TO_TIME(-14400)) <= '2010-07-04 00:00:00' AND ADDTIME(node_data_field_deadline.field_datetime_value2, SEC_TO_TIME(-14400)) >= '2010-06-27 00:00:00')) OR ((node_data_field_deadline.field_deadline_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_deadline_value >= '2010-06-27 00:00:00')))
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 (((node_data_field_deadline.field_datetime_no_to_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_datetime_no_to_value >= '2010-06-27 00:00:00')) OR ((ADDTIME(node_data_field_deadline.field_show_opening_value, SEC_TO_TIME(-14400)) <= '2010-07-04 00:00:00' AND ADDTIME(node_data_field_deadline.field_show_opening_value2, SEC_TO_TIME(-14400)) >= '2010-06-27 00:00:00')) OR ((node_data_field_deadline.field_prints_due_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_prints_due_value >= '2010-06-27 00:00:00')) OR ((node_data_field_deadline.field_prints_hung_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_prints_hung_value >= '2010-06-27 00:00:00')) OR ((node_data_field_deadline.field_prints_removed_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_prints_removed_value >= '2010-06-27 00:00:00')) OR ((ADDTIME(node_data_field_deadline.field_datetime_value, SEC_TO_TIME(-14400)) <= '2010-07-04 00:00:00' AND ADDTIME(node_data_field_deadline.field_datetime_value2, SEC_TO_TIME(-14400)) >= '2010-06-27 00:00:00')) OR ((node_data_field_deadline.field_deadline_value <= '2010-07-04 00:00:00' AND node_data_field_deadline.field_deadline_value >= '2010-06-27 00:00:00')))
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.
|
Sunday |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
|
|
|
|
|
|
|
|
|