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, node_data_field_event_dates.field_event_dat' at line 1 query: SELECT node_data_field_event_dates.field_event_dates_value, CONCAT(EXTRACT(YEAR FROM( REPLACE(node_data_field_event_dates.field_event_dates_value,'T',' '))),'-',LPAD(EXTRACT(MONTH FROM( REPLACE(node_data_field_event_dates.field_event_dates_value,'T',' '))), 2, '0')) AS range, count(node.nid) AS num_nodes, node_data_field_event_dates.field_event_dates_value AS node_data_field_event_dates_field_event_dates_value, node_data_field_event_dates.field_event_dates_value2 AS node_data_field_event_dates_field_event_dates_value2, node.title AS node_title, node.changed AS node_changed, node_data_field_location.field_location_value AS node_data_field_location_field_location_value, node_data_field_location.field_location_format AS node_data_field_location_field_location_format FROM node node LEFT JOIN content_type_training node_data_field_event_dates ON node.vid = node_data_field_event_dates.vid LEFT JOIN content_type_training node_data_field_location ON node.vid = node_data_field_location.vid LEFT JOIN localizernode loc ON loc.nid=node.nid WHERE (loc.locale IN ('en','-') OR loc.locale IS NULL) AND ( (node.type IN ('training')) ) GROUP BY CONCAT(EXTRACT(YEAR FROM( REPLACE(node_data_field_event_dates.field_event_dates_value,'T',' '))),'-',LPAD(EXTRACT(MONTH FROM( REPLACE(node_data_field_event_dates.field_event_dates_value,'T',' '))), 2, '0')) ORDER BY node_data_field_event_dates_field_event_dates_value DESC LIMIT 0, 75 in /home3/lrcnetwo/public_html/hubaihakiev/includes/database.mysql.inc on line 172.