From aa2727248bd80cf8cf4c320db47248a632d3d4fd Mon Sep 17 00:00:00 2001 From: dakkar Date: Fri, 31 Dec 2021 16:41:45 +0000 Subject: fix `recent` limit --- lib/App/MediaControl/DB.rakumod | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/App/MediaControl/DB.rakumod b/lib/App/MediaControl/DB.rakumod index 3d90de8..f49cfab 100644 --- a/lib/App/MediaControl/DB.rakumod +++ b/lib/App/MediaControl/DB.rakumod @@ -143,7 +143,7 @@ class App::MediaControl::DB { method get-recently-watched-folders(Int:D() $limit=20) { self!db: { - .query(qq:to/END/, :$limit).hashes; + .query(qq:to/END/, $limit).hashes; WITH recent(id,watched_time) AS ( SELECT parent_id AS id, MAX(watched_time) AS watched_time FROM files @@ -152,7 +152,7 @@ class App::MediaControl::DB { AND parent_id IS NOT NULL GROUP BY parent_id ORDER BY watched_time DESC - LIMIT $limit + LIMIT ? ) SELECT files.id, files.name, files.is_dir, recent.watched_time FROM files -- cgit v1.2.3