user warning: Unknown column 'term_data.name' in 'where clause'
query: SELECT node.nid AS nid,
node_data_field_pub_year.field_pub_year_value AS node_data_field_pub_year_field_pub_year_value
FROM node node
INNER JOIN content_field_resource_edc_pub node_data_field_resource_edc_pub ON node.vid = node_data_field_resource_edc_pub.vid
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_node term_data ON node.vid = term_data.vid
LEFT JOIN term_data term_data__term_data ON term_data.tid = term_data__term_data.tid AND term_data__term_data.name != 'briefs'
LEFT JOIN content_field_pub_year node_data_field_pub_year ON node.vid = node_data_field_pub_year.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 = 'og_public'))) AND ( (node.status <> 0) AND (node.type in ('online_resources')) AND (node_data_field_resource_edc_pub.field_resource_edc_pub_value = 'No') AND (term_data.name = 'briefs') AND (term_data__term_data.name = 'juvenile justice resources.html')
)ORDER BY node_data_field_pub_year_field_pub_year_value DESC
LIMIT 0, 5 in /home/www/HHD/promoteprevent/drupal-6.14/sites/all/modules/views/includes/view.inc on line 755.
