User:Nikki/Tracks

From MusicBrainz Wiki
< User:Nikki
Revision as of 08:35, 22 April 2013 by Nikki (talk | contribs) (possible out of order tracklists)
(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]';

possible out of order tracklists:

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