Preparing to Dream News
user warning: Unknown column 'node_book.bid' in 'on clause'
query: SELECT DISTINCT(node.nid) AS nid,
node.created AS node_created,
node.title AS node_title,
DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -21600 SECOND), '%Y') AS node_created_year,
DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -21600 SECOND), '%Y%m') AS node_created_month,
DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -21600 SECOND), '%Y%m%d') AS node_created_day
FROM node node
LEFT JOIN book book ON node.nid = book.nid
LEFT JOIN node node_book ON book.bid = node_book.bid
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid AND term_node2.tid = 3
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 = 'simple_access_author'))) AND ( (term_data.vid in ('3')) AND (node.status <> 0) AND (term_node2.tid IS NULL)
)GROUP BY nid
ORDER BY node_created_year DESC, node_created_month DESC, node_created_day DESC
in /home/hapc/houstonannenberg.org/preparingtodream/sites/all/modules/views/includes/view.inc on line 769.