hth: release_stats

Custom SQL query returning 17 rows (hide)

select
  r.title,
  strftime('%Y', r.date) as year,
  count(distinct s.id) as tracks,
  count(distinct v.id) as videos,
  count(distinct p.id) as press
from music_release as r
  left join music_song as s on s.release_id = r.id
  left join music_video as v on v.release_id = r.id
  left join music_press as p on p.release_id = r.id
group by r.id
order by r.date desc

Edit SQL