Connected to Spotify
Edit import of Daily Discover based
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
73
Rows in the result
73
Rows shown
20
The list below is the first 20 of 73 rows; the count above is the whole result.
- import of Daily Discover based (playlist 1663): 73 of 73 membership rows read
The list it would produce
in the order stated above, first 20 of 73- 0 Take Care In Your Dreaming — The Avalanches
- 1 TimeshareCondominium — BONES
- 2 Snow Beach — RATKING
- 3 DIRTY! — JPEGMAFIA
- 4 Battery — Zelooperz
- 5 1:04 PM — Quadry
- 6 Terms & Conditions — Mavie Monroe
- 7 Returns to the Orange Grove — Brokeback
- 8 Ssx — The Hellp
- 9 In Our Angelhood — Cocteau Twins
- 10 Divine Madness — Wondha Mountain
- 11 lollllbye — Kenny Segal
- 12 I'm A Instrument — Bruiser Wolf
- 13 Half the Day Is the Night - Remastered — Gábor Szabó
- 14 Red — 12 RODS
- 15 鴿哨 — 缺省
- 16 Pheel Tha Phonk 1990 — SpaceGhostPurrp
- 17 Sunshine Ward — Amebix
- 18 Virtual Self — Deantoni Parks
- 19 No Now Not Your Face — Liars