Connected to Spotify
Edit [Skiley] Liked Songs - Pt. 103
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
50
Rows in the result
50
Rows shown
20
The list below is the first 20 of 50 rows; the count above is the whole result.
- [Skiley] Liked Songs - Pt. 103 (playlist 1007): 50 of 50 membership rows read
The list it would produce
in the order stated above, first 20 of 50- 0 Punk-Rock Messed You Up, Kid! — Cosmo Swain
- 1 Half Asleep / Half Awake — Cosmo Swain
- 2 Kiss Me Hard — Cosmo Swain
- 3 Hold My Head — Cosmo Swain
- 4 Never Clean My Room — Cosmo Swain
- 5 Nightcrawler (feat. Method Man) — CZARFACE
- 6 Lumberjack Match — CZARFACE
- 7 Ready, Able — Grizzly Bear
- 8 Eventually — Tame Impala
- 9 The Less I Know The Better — Tame Impala
- 10 Let It Happen — Tame Impala
- 11 Rylynn — Don Ross
- 12 Movement I - Awakening — Maneli Jamal
- 13 Shallow Grave — Matthew Santos
- 14 Under the Microscope — Matthew Santos
- 15 65 Hunnid — Vince Staples
- 16 Sunset In Benzes — Rome Fortune
- 17 So — Rome Fortune
- 18 Paid Back Loans - The Range Remix — Rome Fortune
- 19 Mach One (feat. Tunji Ige & lil aaron) — Bones Owens