SELECT c.*, COUNT(*) AS cnt FROM nv_cities AS c, nv_eventos AS e WHERE c.cit_lat BETWEEN 48.735599099999 AND 50.535600900001 AND cit_lon BETWEEN 7.4597190999991 AND 9.2597209000009 AND c.cit_id = e.cit_id AND c.adm_id = 2847618 GROUP BY c.cit_id ORDER BY cnt DESCKonzerte in Worms 2015 - 5gig.de

Orte in Worms