user warning: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'rrada.n.created' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT t.type, t.name, COUNT(n.nid) AS node_count FROM node n INNER JOIN node_type t ON t.type = n.type WHERE n.status = 1 AND t.type IN ('blog', 'announcements', 'image', 'forum', 'article', 'book', 'rishennia', '0') AND n.created BETWEEN 1294185600 AND 1294272000 GROUP BY n.type ORDER BY n.created in /var/www/html/sarny-rda.gov.ua/sites/sarnyrrada.gov.ua/modules/archive/archive.pages.inc on line 177.