- user warning: Unknown column 'node_data_field_pubdate.field_pubdate_value' in 'field list'
query: SELECT COUNT(*) FROM (SELECT DISTINCT node.title AS node_title,
node.nid AS nid,
node_data_field_publication.field_publication_value AS node_data_field_publication_field_publication_value,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_publication.field_pubdate_value AS node_data_field_publication_field_pubdate_value,
node_data_field_publication.field_url_url AS node_data_field_publication_field_url_url,
node_data_field_publication.field_url_title AS node_data_field_publication_field_url_title,
node_data_field_publication.field_url_attributes AS node_data_field_publication_field_url_attributes,
node_data_field_publication.field_pubdetails_value AS node_data_field_publication_field_pubdetails_value,
node_data_field_pubdate.field_pubdate_value AS node_data_field_publication_field_pubdate_value_1
FROM node node
LEFT JOIN content_type_inthenews node_data_field_publication ON node.vid = node_data_field_publication.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 = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') 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 = 'og_public'))) AND ( (node.type in ('inthenews')) AND (node.status <> 0)
)) count_alias in /srv/fasweb/faspublic/sites/all/modules/views/plugins/views_plugin_pager.inc on line 134.
- user warning: Unknown column 'node_data_field_pubdate.field_pubdate_value' in 'field list'
query: SELECT DISTINCT node.title AS node_title,
node.nid AS nid,
node_data_field_publication.field_publication_value AS node_data_field_publication_field_publication_value,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_publication.field_pubdate_value AS node_data_field_publication_field_pubdate_value,
node_data_field_publication.field_url_url AS node_data_field_publication_field_url_url,
node_data_field_publication.field_url_title AS node_data_field_publication_field_url_title,
node_data_field_publication.field_url_attributes AS node_data_field_publication_field_url_attributes,
node_data_field_publication.field_pubdetails_value AS node_data_field_publication_field_pubdetails_value,
node_data_field_pubdate.field_pubdate_value AS node_data_field_publication_field_pubdate_value_1
FROM node node
LEFT JOIN content_type_inthenews node_data_field_publication ON node.vid = node_data_field_publication.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 = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') 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 = 'og_public'))) AND ( (node.type in ('inthenews')) AND (node.status <> 0)
)ORDER BY node_data_field_publication_field_pubdate_value_1 DESC
LIMIT 0, 10 in /srv/fasweb/faspublic/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1093.