SELECT c.*, COUNT(*) AS cnt FROM nv_cities AS c, nv_eventos AS e WHERE c.cit_lat BETWEEN 49.633299099999 AND 51.433300900001 AND cit_lon BETWEEN -4.5000009000009 AND -2.6999990999991 AND c.cit_id = e.cit_id AND c.adm_id = 2651292 GROUP BY c.cit_id ORDER BY cnt DESCGigs in Newton Abbot, buy Newton Abbot concert tickets, concerts in Newton Abbot 2015 - 5gig.co.uk

Places near Newton Abbot