diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-05-24 15:28:42 +0200 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-05-24 15:28:42 +0200 |
commit | 37b48d2aef2b82db461c8227b78e01c5cdd8e9c1 (patch) | |
tree | a37e26317a12f52e6c18c4b1b761f7ad36626ba3 /db/itemmapper.php | |
parent | 0fe7d8dd7ea1b61ff35cf071e7688332ac5d342e (diff) |
fix a bug that would not display items of feeds without folders
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r-- | db/itemmapper.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index cd46678b7..0f94b4301 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -59,9 +59,10 @@ class ItemMapper extends Mapper implements IMapper { 'AND `feeds`.`deleted_at` = 0 ' . 'AND `feeds`.`user_id` = ? ' . $prependTo . - 'JOIN `*PREFIX*news_folders` `folders` ' . + 'LEFT OUTER JOIN `*PREFIX*news_folders` `folders` ' . 'ON `folders`.`id` = `feeds`.`folder_id` ' . - 'AND `folders`.`deleted_at` = 0 ' . + 'WHERE `feeds`.`folder_id` = 0 ' . + 'OR `folders`.`deleted_at` = 0 ' . 'ORDER BY `items`.`id` DESC'; } |