diff options
author | Jesse Luehrs <doy@tozt.net> | 2013-10-01 01:45:49 -0400 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2013-10-01 01:46:31 -0400 |
commit | ac66257c1052c15c8a87a5cd9c8022ebfcefd582 (patch) | |
tree | 913c46602cedee0e5be6d7d0037aff86e88220a2 /aliases | |
parent | ec324fd2396fee79d7d37d05b5b76d160ddda09b (diff) | |
download | conf-ac66257c1052c15c8a87a5cd9c8022ebfcefd582.tar.gz conf-ac66257c1052c15c8a87a5cd9c8022ebfcefd582.zip |
also exclude recently listened tracks here
Diffstat (limited to 'aliases')
-rw-r--r-- | aliases | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -107,7 +107,7 @@ function svst { } function pick_music { lastfm_export --user doyster --dsn dbi:SQLite:${HOME}/.tracks.sqlite - sqlite3 ${HOME}/.tracks.sqlite "SELECT artist FROM yearly_tracks GROUP BY artist ORDER BY count(artist) * (strftime('%s') - max(timestamp)) DESC LIMIT $([ -z "$1" ] && echo 20 || echo $1)" + 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)" } function rand_music { lastfm_export --user doyster --dsn dbi:SQLite:${HOME}/.tracks.sqlite |