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 'range, count( DISTINCT(node.nid)) AS num_nodes FROM dl_node node LEFT JOIN dl_c' at line 1 query: SELECT node_data_field_datetime.field_datetime_value, CONCAT(EXTRACT(YEAR FROM(( REPLACE(node_data_field_datetime.field_datetime_value,'T',' ') + INTERVAL (3600) SECOND)))) AS range, count( DISTINCT(node.nid)) AS num_nodes FROM dl_node node LEFT JOIN dl_content_field_datetime node_data_field_datetime ON node.vid = node_data_field_datetime.vid INNER JOIN dl_node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.type IN ('wr_event')) AND (( REPLACE(node_data_field_datetime.field_datetime_value,'T',' ') + INTERVAL (3600) SECOND) < (NOW() + INTERVAL (-82800) SECOND)) ) GROUP BY CONCAT(EXTRACT(YEAR FROM(( REPLACE(node_data_field_datetime.field_datetime_value,'T',' ') + INTERVAL (3600) SECOND)))) LIMIT 0, 10 in /home/www/251987c450e98a56bb07968682ef15c5/web/includes/database.mysql.inc on line 172.