diff options
Diffstat (limited to 'backend/db/queries/feeds.sql')
| -rw-r--r-- | backend/db/queries/feeds.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/backend/db/queries/feeds.sql b/backend/db/queries/feeds.sql index acf36d2..094a0f8 100644 --- a/backend/db/queries/feeds.sql +++ b/backend/db/queries/feeds.sql @@ -37,3 +37,10 @@ WHERE is_subscribed = 1; UPDATE feeds SET is_subscribed = 0 WHERE id = ?; + +-- name: GetFeedUnreadCounts :many +SELECT f.id as feed_id, COUNT(a.id) as unread_count +FROM feeds AS f +LEFT JOIN articles AS a ON f.id = a.feed_id AND a.is_read = 0 +WHERE f.is_subscribed = 1 AND f.user_id = ? +GROUP BY f.id; |