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 node node LEFT JOIN content' at line 1 query: SELECT DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m') AS range, count( DISTINCT(node.nid)) AS num_nodes FROM node node LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid 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 = 1 AND na.realm = 'term_access'))) AND ( (node.status = '1') AND (node.type IN ('event')) AND (DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2012-02-09') ) GROUP BY DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m') LIMIT 0, 6 in /var/www/drupal-5.x-live/includes/database.mysqli.inc on line 156.