hth: gig_locations

Custom SQL query returning 318 rows (hide)

select
    g.date,
    v.name as venue,
    SUBSTR(v.city, 0, INSTR(v.city, ',')) as city,
    SUBSTR(v.city, INSTR(v.city, ',') + 2, 2) as state,
    v.latitude,
    v.longitude
from shows_gig as g
  join shows_venue as v on g.venue_id = v.id
where
    longitude between -124.7844079 and -66.9513812
    and latitude between 24.7433195 and 49.3457868
order by g.date desc

Edit SQL