diff options
| author | Andrew Dolgov <[email protected]> | 2015-09-13 15:59:21 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2015-09-13 15:59:21 +0300 |
| commit | 6b860bd9d25ef69daded8435f7991d64974b6cc1 (patch) | |
| tree | 7e2bb74fea11beb180a83fd5e7f19d49d3670814 /include/functions2.php | |
| parent | dbeef0ca670df713b448d317bd47f47d135e5b8f (diff) | |
recently read: limit query by last_read
Diffstat (limited to 'include/functions2.php')
| -rw-r--r-- | include/functions2.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/include/functions2.php b/include/functions2.php index a135049a5..fb8a6a3d0 100644 --- a/include/functions2.php +++ b/include/functions2.php @@ -608,9 +608,9 @@ $query_strategy_part = "unread = false AND last_read IS NOT NULL"; if (DB_TYPE == "pgsql") { - $query_strategy_part .= " AND date_entered > NOW() - INTERVAL '1 DAY' "; + $query_strategy_part .= " AND last_read > NOW() - INTERVAL '1 DAY' "; } else { - $query_strategy_part .= " AND date_entered > DATE_SUB(NOW(), INTERVAL 1 DAY) "; + $query_strategy_part .= " AND last_read > DATE_SUB(NOW(), INTERVAL 1 DAY) "; } $vfeed_query_part = "ttrss_feeds.title AS feed_title,"; |