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 node node LEFT JOIN content_type_gazet' at line 1 query: SELECT node_data_field__eldona_dato.field__eldona_dato_value, CONCAT(EXTRACT(YEAR FROM( REPLACE(node_data_field__eldona_dato.field__eldona_dato_value,'T',' ')))) AS range, count(node.nid) AS num_nodes FROM node node LEFT JOIN content_type_gazetanumero node_data_field__eldona_dato ON node.vid = node_data_field__eldona_dato.vid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='eo' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.type IN ('gazetanumero')) AND (EXTRACT(YEAR FROM( REPLACE(node_data_field__eldona_dato.field__eldona_dato_value,'T',' '))) >= 2000) AND (EXTRACT(YEAR FROM( REPLACE(node_data_field__eldona_dato.field__eldona_dato_value,'T',' '))) < 2010) ) GROUP BY CONCAT(EXTRACT(YEAR FROM( REPLACE(node_data_field__eldona_dato.field__eldona_dato_value,'T',' ')))) in /home/stelaroo/public_html/gazetejo/includes/database.mysql.inc on line 174.