X-Git-Url: https://git.kaliko.me/?a=blobdiff_plain;f=sima%2Flib%2Fsimadb.py;h=07794dc6d24f079ea6cc5b11e234e6e02e15f4b4;hb=6e0cb104973681f2344de9c5ae4f04c62686401b;hp=60844a2af38854618fed17d49d993459d6582a8a;hpb=ea1864a3e4e5b879a9ae84d3d97c23eebb0dc77a;p=mpd-sima.git diff --git a/sima/lib/simadb.py b/sima/lib/simadb.py index 60844a2..07794dc 100644 --- a/sima/lib/simadb.py +++ b/sima/lib/simadb.py @@ -542,7 +542,7 @@ class SimaDB: LEFT OUTER JOIN tracks_genres ON tracks_genres.track = tracks.id LEFT OUTER JOIN artists ON tracks.artist = artists.id LEFT OUTER JOIN genres ON genres.id = tracks_genres.genre - WHERE history.last_play > ? + WHERE history.last_play > ? AND genres.name NOT NULL ORDER BY history.last_play DESC """, (date.isoformat(' '),)) genres = list()