June 2010

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), DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 19800' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 19800 SECOND), '%Y%m%d%H%i') AS node_created_minute FROM node node 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 = 'domain_site') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner') OR (na.gid = 0 AND na.realm = 'tac_lite') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( (node.status <> 0) AND (DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 19800 SECOND), '%Y%m') = '201006') )ORDER BY node_created_minute DESC LIMIT 0, 10 in /var/www/html/multiple/sites/all/modules/views/includes/view.inc on line 755.