diff options
Diffstat (limited to 'app/Models/FeedDAO.php')
| -rw-r--r-- | app/Models/FeedDAO.php | 13 |
1 files changed, 3 insertions, 10 deletions
diff --git a/app/Models/FeedDAO.php b/app/Models/FeedDAO.php index ddc2057db..dcabf337b 100644 --- a/app/Models/FeedDAO.php +++ b/app/Models/FeedDAO.php @@ -497,16 +497,9 @@ SQL; GROUP BY id_feed ) UPDATE `_feed` - SET `cache_nbEntries` = COALESCE(( - SELECT c.total_entries - FROM entry_counts AS c - WHERE c.id_feed = `_feed`.id - ), 0), - `cache_nbUnreads` = COALESCE(( - SELECT c.unread_entries - FROM entry_counts AS c - WHERE c.id_feed = `_feed`.id - ), 0) + LEFT JOIN entry_counts ON entry_counts.id_feed = `_feed`.id + SET `cache_nbEntries` = COALESCE(entry_counts.total_entries, 0), + `cache_nbUnreads` = COALESCE(entry_counts.unread_entries, 0) WHERE $whereFeedIds SQL; $stm = $this->pdo->prepare($sql); |