diff options
| author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-04-25 10:23:02 +0200 |
|---|---|---|
| committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-04-25 10:23:15 +0200 |
| commit | 23f8a09489fad279ff6d2f33d4e5a53eff200d23 (patch) | |
| tree | 1da8dae8c10120e28c11b7108d142e0b825aa546 /db | |
| parent | ad790bafb66ca1f08f66d07563419c8ecaa42443 (diff) | |
fix broken sql statement fix #122
Diffstat (limited to 'db')
| -rw-r--r-- | db/itemmapper.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index 225cfb9b9..59654e62a 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -224,7 +224,7 @@ class ItemMapper extends Mapper implements IMapper { $status = StatusFlag::STARRED | StatusFlag::UNREAD; $sql = 'SELECT COUNT(*) `size`, `feed_id` ' . 'FROM `*PREFIX*news_items` ' . - 'AND NOT ((`status` & ?) > 0) ' . + 'WHERE NOT ((`status` & ?) > 0) ' . 'GROUP BY `feed_id` ' . 'HAVING COUNT(*) > ?'; $params = array($status, $threshold); |