mySQL error with query SELECT itime, SUBSTRING(itime,1,4) AS Year, SUBSTRING(itime,6,2) AS Month, SUBSTRING(itime,9,2) as Day FROM nucleus_item WHERE iblog=1 and itime <='2020-04-02 13:46:08' and idraft=0 GROUP BY Year ORDER BY itime DESC: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ic4u2_roodpetje.nucleus_item.itime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

december 2003
november 2003
oktober 2003
september 2003
augustus 2003
juli 2003
juni 2003
mei 2003
april 2003
maart 2003
februari 2003
januari 2003
december 2002
november 2002
oktober 2002
september 2002
augustus 2002
juli 2002
juni 2002
mei 2002
april 2002
maart 2002
februari 2002
januari 2002
december 2001
november 2001
oktober 2001
september 2001
augustus 2001