- user warning: Unknown column 'node_data_field_date.field_date_value' in 'where clause'
query: SELECT DISTINCT node.nid AS nid,
node_data_field_location.field_location_value AS node_data_field_location_field_location_value,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_location.field_event_id_value AS node_data_field_location_field_event_id_value,
node.title AS node_title,
node_data_field_location.field_date_value AS node_data_field_location_field_date_value,
node_data_field_location.field_date_value2 AS node_data_field_location_field_date_value2,
node_data_field_location.field_type_value AS node_data_field_location_field_type_value,
node_data_field_location.field_read_more_value AS node_data_field_location_field_read_more_value,
node_data_field_location.field_chapter_id_value AS node_data_field_location_field_chapter_id_value,
node_data_field_location.field_display_on_national_value AS node_data_field_location_field_display_on_national_value,
node.changed AS node_changed
FROM node node
LEFT JOIN content_type_event node_data_field_location ON node.vid = node_data_field_location.vid
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'nodeaccess_rid') OR (na.gid = 0 AND na.realm = 'nodeaccess_uid') OR (na.gid = 0 AND na.realm = 'nodeaccess_author') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (node.status <> 0)
AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-14400)), '%Y-%m') <= '2012-05' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(-14400)), '%Y-%m') >= '2012-05'))
)ORDER BY node_changed ASC
in /usr/www/users/asmp/cmstest/modules/views/includes/view.inc on line 775.
- user warning: Unknown column 'node_data_field_date.field_date_value' in 'where clause'
query: SELECT DISTINCT node.nid AS nid,
node_data_field_location.field_location_value AS node_data_field_location_field_location_value,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_location.field_event_id_value AS node_data_field_location_field_event_id_value,
node.title AS node_title,
node_data_field_location.field_date_value AS node_data_field_location_field_date_value,
node_data_field_location.field_date_value2 AS node_data_field_location_field_date_value2,
node_data_field_location.field_type_value AS node_data_field_location_field_type_value,
node_data_field_location.field_read_more_value AS node_data_field_location_field_read_more_value,
node_data_field_location.field_chapter_id_value AS node_data_field_location_field_chapter_id_value,
node_data_field_location.field_display_on_national_value AS node_data_field_location_field_display_on_national_value,
node.changed AS node_changed
FROM node node
LEFT JOIN content_type_event node_data_field_location ON node.vid = node_data_field_location.vid
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'nodeaccess_rid') OR (na.gid = 0 AND na.realm = 'nodeaccess_uid') OR (na.gid = 0 AND na.realm = 'nodeaccess_author') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (node.status <> 0)
AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-14400)), '%Y-%m') <= '2012-05' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(-14400)), '%Y-%m') >= '2012-05'))
)ORDER BY node_changed ASC
in /usr/www/users/asmp/cmstest/modules/views/includes/view.inc on line 775.
|
Sunday |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ASMP Seminars
National Events
Chapter Events
Industry Events
