Connected to Spotify
Edit Kentucy derby
order sort one playlist by one stated rule
A preview: the list this operation would produce, and every row it would remove. Nothing has been changed, here or on Spotify — write-back is D-9.
What was asked for
the operation, the rule and the seed in use- order: sort one playlist by one stated rule
- order: playlist — the playlist's own order — the position Spotify gave each track, then the membership row id; a merge keeps the sources in the order they were given
- order: playlist — the playlist's own order — the position Spotify gave each track, then the membership row id; a merge keeps the sources in the order they were given
- keys: source, position, playlist_track_id
Choose an operation
every choice is a link — the URL is this screen's whole state
op
order
- order by playlist — the playlist's own order — the position Spotify gave each track, then the membership row id; a merge keeps the sources in the order they were given
- order by title — track title A→Z, ignoring case, then the row's playlist and id
- order by artist — artist A→Z ignoring case, then title, then the row's playlist and id
- order by duration — longest first, with a track of unknown duration last, then the row's playlist and id
- order by tempo — slowest first, with a track of unknown tempo last, then the row's playlist and id
- order by energy — most energetic first, with a track of unknown energy last, then the row's playlist and id
- order by added — when it was added to the playlist, oldest first, with a row whose addition moment was never recorded last, then the row's playlist and id
The counts
Rows read
3
Rows in the result
3
Rows shown
3
- Kentucy derby (playlist 968): 3 of 3 membership rows read
The list it would produce
in the order stated above- 0 Kyoto — Phoebe Bridgers
- 1 Love Reign O'er Me — The Who
- 2 Burn the Witch — Radiohead