Videos
- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DISTINCT(node.nid),
node.created AS node_created
FROM node node
LEFT JO...' at line 1
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid),
node.created AS node_created
FROM node node
LEFT JOIN comments comments ON node.nid = comments.nid
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( node.type in ('video')
)ORDER BY node_created DESC
) count_alias in /home/redearth/public_html/home/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 MariaDB server version for the right syntax to use near 'DISTINCT(node.nid),
node.created AS node_created
FROM node node
LEFT JO...' at line 1
query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid),
node.created AS node_created
FROM node node
LEFT JOIN comments comments ON node.nid = comments.nid
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( node.type in ('video')
)ORDER BY node_created DESC
LIMIT 0, 10 in /home/redearth/public_html/home/modules/views/includes/view.inc on line 755.