User:Nikki/Tracks

From MusicBrainz Wiki
Jump to navigationJump to search

select distinct r.gid from track t join medium m on m.tracklist=t.tracklist join release r on r.id=m.release where t.position::text != t.number and t.number !~ '[^0-9]' and t.number != ('0'||t.position::text);

possible out of order tracklists: