ERROR (1055) : 'gas24de_redaxo.tankstellen.x' isn't in GROUP BY
query : SELECT x, y, ort, ort_gruppe, SUBSTRING(plz,1,3) AS plz_gruppe FROM tankstellen WHERE status = 'egt' AND land = 'CHE' GROUP BY ort_gruppe