user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid),
node_revisions.teaser AS node_revisions_teaser,
node_r' at line 1
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.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.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.sticky AS topic_is_sticky,
forum.tid AS topic_actual_forum
FROM node node
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
INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN forum forum ON node.vid = forum.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 = 'forum_access'))) AND ( (node.status <> 0) AND (term_data.vid in ('10')) AND (node_comment_statistics.comment_count = 0)
)ORDER BY node_sticky DESC
) count_alias in /home/bychess/public_html/bychesscom/sites/all/modules/views/includes/view.inc on line 729.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(node.nid),
node_revisions.teaser AS node_revisions_teaser,
node_r' at line 1
query: SELECT DISTINCT(node.nid) AS DISTINCT(node.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.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.sticky AS topic_is_sticky,
forum.tid AS topic_actual_forum
FROM node node
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
INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN forum forum ON node.vid = forum.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 = 'forum_access'))) AND ( (node.status <> 0) AND (term_data.vid in ('10')) AND (node_comment_statistics.comment_count = 0)
)ORDER BY node_sticky DESC
LIMIT 0, 20 in /home/bychess/public_html/bychesscom/sites/all/modules/views/includes/view.inc on line 755.