User:Nikki/Tracks

From MusicBrainz Wiki
< User:Nikki
Revision as of 08:47, 22 April 2013 by Nikki (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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:

Retrieved from "https://wiki.musicbrainz.org/index.php?title=User:Nikki/Tracks&oldid=63223"