Connected to Spotify
Edit Trending 20 Sweden
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
16
Rows in the result
16
Rows shown
16
- Trending 20 Sweden (playlist 1237): 16 of 16 membership rows read
The list it would produce
in the order stated above- 0 Kuku — Butrint Imeri
- 1 MONEY — LISA
- 2 I Still Have Faith In You — ABBA
- 3 Don't Shut Me Down — ABBA
- 4 JOKER — HAVAL
- 5 Hunter’s Moon — Black Ghost
- 6 My Universe — Coldplay
- 7 Eld & lågor — Victor Leksell
- 8 LALISA — LISA
- 9 STAY (with Justin Bieber) — The Kid LAROI
- 10 The Feels — TWICE
- 11 365 — Hov1
- 12 Ghost — Justin Bieber
- 13 Waayo Waayo — Sharma Boy
- 14 Savage — aespa
- 15 THATS WHAT I WANT — Lil Nas X