SELECT c.*, COUNT(*) AS cnt FROM nv_cities AS c, nv_eventos AS e WHERE c.cit_lat BETWEEN 48.283299099999 AND 50.083300900001 AND cit_lon BETWEEN -3.0000009000009 AND -1.1999990999991 AND c.cit_id = e.cit_id AND c.adm_id = 3165244 GROUP BY c.cit_id ORDER BY cnt DESCConcerti Saint Helier 2015 - 5gig.it

Luoghi vicino a Saint Helier