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_date.field_date_value, CONCAT(EXTRACT(YEAR FROM( REPLACE(node_data_field_date.field_date_value,'T',' ')))) AS range, count( DISTINCT(node.nid)) AS num_nodes FROM dl_node node LEFT JOIN dl_content_field_date node_data_field_date ON node.vid = node_data_field_date.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_news')) ) GROUP BY CONCAT(EXTRACT(YEAR FROM( REPLACE(node_data_field_date.field_date_value,'T',' ')))) LIMIT 0, 10 in /home/www/251987c450e98a56bb07968682ef15c5/web/includes/database.mysql.inc on line 172.