hth: release_aggregates

Custom SQL query returning 7 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 published_releases as r join published_songs as s on s.release_id = r.id join published_videos as v on v.release_id = r.id join published_press as p on p.release_id = r.id where r.publish group by r.id order by r.date desc

Edit SQL