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(node.nid) AS num_nodes FROM dr519_node node LEFT JOIN dr519_conten' at line 1 query: SELECT DATE_FORMAT(STR_TO_DATE(node_data_field_events_date.field_events_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') AS range, count(node.nid) AS num_nodes FROM dr519_node node LEFT JOIN dr519_content_field_events_date node_data_field_events_date ON node.vid = node_data_field_events_date.vid WHERE (node.type IN ('events','extra_event')) GROUP BY DATE_FORMAT(STR_TO_DATE(node_data_field_events_date.field_events_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') LIMIT 0, 50 in /is/htdocs/wp1030098_9G0MNRGJ5S/tito/includes/database.mysql.inc on line 174.