Active forum topics
- user warning: Unknown column 'node_comment_statistics.last_updated' in 'field list' query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid_1, node.nid AS nid, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node.type AS node_type, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, node.created AS node_created, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_counter.totalcount AS node_counter_totalcount, COALESCE(ncs_users.name, node_comment_statistics.last_comment_name) AS node_comment_statistics_last_comment_name, ncs_users.name AS ncs_users_name, node_comment_statistics.last_comment_uid AS node_comment_statistics_last_comment_uid, GREATEST(node.changed, node_comment_statistics.last_comment_timestamp) AS node_comment_statistics_last_updated, node.sticky AS node_sticky, node.comment AS node_comment, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, node_comment_statistics.last_updated AS node_comment_statistics_last_updated_1, node.sticky AS topic_is_sticky, forum.tid AS topic_actual_forum FROM dpnode node LEFT JOIN dpterm_node term_node ON node.vid = term_node.vid LEFT JOIN dpterm_data term_data ON term_node.tid = term_data.tid LEFT JOIN dpnode_revisions node_revisions ON node.vid = node_revisions.vid INNER JOIN dpusers users ON node.uid = users.uid INNER JOIN dpnode_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN dpnode_counter node_counter ON node.nid = node_counter.nid LEFT JOIN dpusers ncs_users ON node_comment_statistics.last_comment_uid = ncs_users.uid AND ncs_users.uid != '0' LEFT JOIN dpforum forum ON node.vid = forum.vid WHERE (node.status <> 0) AND (term_data.vid in ('1')) GROUP BY nid_1 ORDER BY node_comment_statistics_last_updated DESC, node_comment_statistics_last_updated_1 DESC ) count_alias in /var/www/vhosts/chinesemusic.co.uk/httpdocs/home/sites/all/modules/views/plugins/views_plugin_pager.inc on line 134.
- user warning: Unknown column 'node_comment_statistics.last_updated' in 'field list' query: SELECT DISTINCT(node.nid) AS nid_1, node.nid AS nid, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node.type AS node_type, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, node.created AS node_created, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_counter.totalcount AS node_counter_totalcount, COALESCE(ncs_users.name, node_comment_statistics.last_comment_name) AS node_comment_statistics_last_comment_name, ncs_users.name AS ncs_users_name, node_comment_statistics.last_comment_uid AS node_comment_statistics_last_comment_uid, GREATEST(node.changed, node_comment_statistics.last_comment_timestamp) AS node_comment_statistics_last_updated, node.sticky AS node_sticky, node.comment AS node_comment, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, node_comment_statistics.last_updated AS node_comment_statistics_last_updated_1, node.sticky AS topic_is_sticky, forum.tid AS topic_actual_forum FROM dpnode node LEFT JOIN dpterm_node term_node ON node.vid = term_node.vid LEFT JOIN dpterm_data term_data ON term_node.tid = term_data.tid LEFT JOIN dpnode_revisions node_revisions ON node.vid = node_revisions.vid INNER JOIN dpusers users ON node.uid = users.uid INNER JOIN dpnode_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN dpnode_counter node_counter ON node.nid = node_counter.nid LEFT JOIN dpusers ncs_users ON node_comment_statistics.last_comment_uid = ncs_users.uid AND ncs_users.uid != '0' LEFT JOIN dpforum forum ON node.vid = forum.vid WHERE (node.status <> 0) AND (term_data.vid in ('1')) GROUP BY nid_1 ORDER BY node_comment_statistics_last_updated DESC, node_comment_statistics_last_updated_1 DESC LIMIT 0, 20 in /var/www/vhosts/chinesemusic.co.uk/httpdocs/home/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1093.
No new topics.