hth: venue_stats

Custom SQL query returning 192 rows (hide)

select
    v.name,
    v.city,
    count(g.id) as gigs,
    min(g.date) as first_gig,
    max(g.date) as last_gig,
    v.website,
    v.latitude,
    v.longitude
from shows_venue as v
    join shows_gig as g on g.venue_id = v.id
where
    longitude between -124.7844079 and -66.9513812
    and latitude between 24.7433195 and 49.3457868
group by v.id
order by gigs desc, last_gig desc

Edit SQL