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 'AS versus_votes FROM node node INNER JOIN users users ON node.uid = users.uid ' at line 1 query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, (SELECT COUNT(value) AS votes FROM votingapi_vote 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 ( value = node.nid) AS versus_votes FROM node node INNER JOIN users users ON node.uid = users.uid 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 = '1') ) ORDER BY versus_votes DESC LIMIT 0, 100 in /home/nathanra/public_html/hondarvf/includes/database.mysql.inc on line 172.