summaryrefslogtreecommitdiffstats
path: root/aliases
diff options
context:
space:
mode:
authorJesse Luehrs <doy@tozt.net>2012-03-20 18:46:21 -0500
committerJesse Luehrs <doy@tozt.net>2012-03-20 18:46:41 -0500
commit3cbce3f0894b1bbefb160f297836f19ec507062b (patch)
treecaff7f4c87d300e82540a9da108f96834773e2cc /aliases
parent85148ca9d64f8871e66b4f6a0e3114696b42bd29 (diff)
downloadconf-3cbce3f0894b1bbefb160f297836f19ec507062b.tar.gz
conf-3cbce3f0894b1bbefb160f297836f19ec507062b.zip
actually, let's ignore plays more than a year old entirely
Diffstat (limited to 'aliases')
-rw-r--r--aliases2
1 files changed, 1 insertions, 1 deletions
diff --git a/aliases b/aliases
index b3088e0..f32115f 100644
--- a/aliases
+++ b/aliases
@@ -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)"
}
# }}}