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.title AS node_title FROM node node INNER JOIN vid' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.title AS node_title FROM node node INNER JOIN video_terms_similarity 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 = 'tac_lite') OR (na.gid = 57 AND na.realm = 'tac_lite') OR (na.gid = 29 AND na.realm = 'tac_lite') OR (na.gid = 90 AND na.realm = 'tac_lite') OR (na.gid = 68 AND na.realm = 'tac_lite') OR (na.gid = 69 AND na.realm = 'tac_lite') OR (na.gid = 58 AND na.realm = 'tac_lite') OR (na.gid = 91 AND na.realm = 'tac_lite') OR (na.gid = 92 AND na.realm = 'tac_lite') OR (na.gid = 84 AND na.realm = 'tac_lite') OR (na.gid = 93 AND na.realm = 'tac_lite') OR (na.gid = 49 AND na.realm = 'tac_lite') OR (na.gid = 51 AND na.realm = 'tac_lite') OR (na.gid = 52 AND na.realm = 'tac_lite') OR (na.gid = 53 AND na.realm = 'tac_lite') OR (na.gid = 54 AND na.realm = 'tac_lite') OR (na.gid = 55 AND na.realm = 'tac_lite') OR (na.gid = 56 AND na.realm = 'tac_lite') OR (na.gid = 89 AND na.realm = 'tac_lite') OR (na.gid = 86 AND na.realm = 'tac_lite') OR (na.gid = 85 AND na.realm = 'tac_lite') OR (na.gid = 87 AND na.realm = 'tac_lite'))) AND ( ((node.status <> 0) AND (node.language in ('es', '')) AND (node.type in ('video')) AND (IF(video_terms_similarity.nid1 = 175, video_terms_similarity.nid2, video_terms_similarity.nid1) = node.nid)) AND ((video_terms_similarity.nid1 = 175) OR (video_terms_similarity.nid2 = 175)) ) LIMIT 0, 10 in /home/crescent/public_html/drupal-6.x/sites/all/modules/views/includes/view.inc on line 755.