blob: e667960d222db4c2c2adc4abd36fb20b9f7133ca (
plain) (
blame)
1
2
3
4
|
#!/bin/bash
lastfm_export --user doyster --dsn dbi:SQLite:${HOME}/.tracks.sqlite
sqlite3 ${HOME}/.tracks.sqlite "SELECT artist FROM yearly_tracks WHERE artist NOT IN (SELECT DISTINCT(artist) FROM weekly_tracks) GROUP BY artist ORDER BY count(artist) * (strftime('%s') - max(timestamp)) DESC LIMIT $([ -z "$1" ] && echo 20 || echo $1)"
|