Banners & Art: add your vote
- 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),
votingapi_cache.value AS votingapi_cache_value
FROM node' at line 1
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid),
votingapi_cache.value AS votingapi_cache_value
FROM node node
LEFT JOIN votingapi_cache votingapi_cache ON node.nid = votingapi_cache.content_id AND votingapi_cache.content_type = 'node'
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( (votingapi_cache.value > 4) AND (node.type in ('image'))
)ORDER BY votingapi_cache_value DESC
) AS count_alias in /home/content/p/e/a/peasbody/html/cctriage/sites/default/modules/views/includes/view.inc on line 652.
- 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),
votingapi_cache.value AS votingapi_cache_value
FROM node' at line 1
query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid),
votingapi_cache.value AS votingapi_cache_value
FROM node node
LEFT JOIN votingapi_cache votingapi_cache ON node.nid = votingapi_cache.content_id AND votingapi_cache.content_type = 'node'
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( (votingapi_cache.value > 4) AND (node.type in ('image'))
)ORDER BY votingapi_cache_value DESC
LIMIT 0, 3 in /home/content/p/e/a/peasbody/html/cctriage/sites/default/modules/views/includes/view.inc on line 677.
