1064 - 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 'GROUP BY messe.messe_ort ORDER BY anzahl DESC LIMIT 0, 10' at line 1

SELECT DISTINCT(messe_ort), count( messe_ort ) AS anzahl FROM messe LEFT JOIN messe_termine ON messe.messe_id = messe_termine.messe_id WHERE (messe_termine.messe_start > CURDATE() OR ( CURDATE() BETWEEN messe_termine.messe_start AND messe_termine.messe_ende)) AND messe_land= GROUP BY messe.messe_ort ORDER BY anzahl DESC LIMIT 0, 10

[TEP STOP]