Contents

select shows.uuid, shows.year, shows.month, shows.day
from shows left outer join show_sets on shows.uuid = show_sets.show_uuid
where
  show_sets.uuid is null
order by shows.year, shows.month, shows.day
;

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
gdshowsdb-4.0.2	empty_shows.sql
gdshowsdb-4.0.1	empty_shows.sql
gdshowsdb-4.0.0	empty_shows.sql
gdshowsdb-3.0.0	empty_shows.sql
gdshowsdb-2.1.0	empty_shows.sql