Active forum posts
- 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.type AS node_type, node.title AS node_title, t' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, 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, 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_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node.comment AS node_comment, 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 users users ON node.uid = users.uid INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN users ncs_users ON node_comment_statistics.last_comment_uid = ncs_users.uid AND ncs_users.uid != '0' LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid 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 = 0 AND na.realm = 'flag_friend') OR (na.gid = 1 AND na.realm = 'friendlist_node_access_ALL') OR (na.gid = 0 AND na.realm = 'friendlist_access_node_access_author') OR (na.gid = 0 AND na.realm = 'user_relationship_node_access_author'))) AND ( (node.status <> 0) AND (term_data.vid in ('3')) )ORDER BY node_comment_statistics_last_updated DESC, node_sticky DESC ) count_alias in /home/elitemar/public_html/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.type AS node_type, node.title AS node_title, t' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, 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, 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_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node.comment AS node_comment, 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 users users ON node.uid = users.uid INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN users ncs_users ON node_comment_statistics.last_comment_uid = ncs_users.uid AND ncs_users.uid != '0' LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid 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 = 0 AND na.realm = 'flag_friend') OR (na.gid = 1 AND na.realm = 'friendlist_node_access_ALL') OR (na.gid = 0 AND na.realm = 'friendlist_access_node_access_author') OR (na.gid = 0 AND na.realm = 'user_relationship_node_access_author'))) AND ( (node.status <> 0) AND (term_data.vid in ('3')) )ORDER BY node_comment_statistics_last_updated DESC, node_sticky DESC LIMIT 0, 20 in /home/elitemar/public_html/modules/views/includes/view.inc on line 755.
No new posts in this forum.
Status
Anonymous
does not have a status.
