diff options
author | Jesse Luehrs <doy@tozt.net> | 2012-03-20 18:46:21 -0500 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2012-03-20 18:46:41 -0500 |
commit | 3cbce3f0894b1bbefb160f297836f19ec507062b (patch) | |
tree | caff7f4c87d300e82540a9da108f96834773e2cc /aliases | |
parent | 85148ca9d64f8871e66b4f6a0e3114696b42bd29 (diff) | |
download | conf-3cbce3f0894b1bbefb160f297836f19ec507062b.tar.gz conf-3cbce3f0894b1bbefb160f297836f19ec507062b.zip |
actually, let's ignore plays more than a year old entirely
Diffstat (limited to 'aliases')
-rw-r--r-- | aliases | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -129,7 +129,7 @@ function svst { } function pick_music { lastfm_export --user doyster --dsn dbi:SQLite:${HOME}/.tracks.sqlite - sqlite3 ${HOME}/.tracks.sqlite "SELECT artist FROM tracks GROUP BY artist HAVING strftime('%s') - max(timestamp) < 60*60*24*365 ORDER BY count(artist) * (strftime('%s') - max(timestamp)) DESC LIMIT $([ -z "$1" ] && echo 20 || echo $1)" + sqlite3 ${HOME}/.tracks.sqlite "SELECT artist FROM tracks WHERE strftime('%s') - timestamp < 60*60*24*365 GROUP BY artist ORDER BY count(artist) * (strftime('%s') - max(timestamp)) DESC LIMIT $([ -z "$1" ] && echo 20 || echo $1)" } # }}} |