Video Gallery
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_kaltura.kaltura_thumbnail_url AS node_kaltura_kaltur' at line 1
query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid),
node_kaltura.kaltura_thumbnail_url AS node_kaltura_kaltura_thumbnail_url,
node.title AS node_title,
node_kaltura.kaltura_duration AS node_kaltura_kaltura_duration,
node_kaltura.kaltura_entryId AS node_kaltura_kaltura_entryId,
comments.subject AS comments_subject,
comments.cid AS comments_cid,
comments.nid AS comments_nid,
node_counter.totalcount AS node_counter_totalcount,
node.created AS node_created,
node.sticky AS node_sticky
FROM node node
LEFT JOIN node_kaltura node_kaltura ON node.nid = node_kaltura.nid
LEFT JOIN comments comments ON node.nid = comments.nid
LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid
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 = 'photos_access_author') OR (na.gid = 0 AND na.realm = 'photos_access'))) AND ( (node.type in ('kaltura_entry', 'kaltura_mix')) AND (node.status <> 0) AND (node_kaltura.kaltura_media_type in ('1', '6')) AND (node_kaltura.kaltura_video_comment in ('0'))
)ORDER BY node_created DESC, node_sticky DESC
LIMIT 0, 20 in /home/cebuesta/public_html/boxing/sites/all/modules/views/includes/view.inc on line 725.