summaryrefslogtreecommitdiffstats
path: root/db/itemmapper.php
diff options
context:
space:
mode:
authorBernhard Posselt <nukeawhale@gmail.com>2013-05-24 15:28:42 +0200
committerBernhard Posselt <nukeawhale@gmail.com>2013-05-24 15:28:42 +0200
commit37b48d2aef2b82db461c8227b78e01c5cdd8e9c1 (patch)
treea37e26317a12f52e6c18c4b1b761f7ad36626ba3 /db/itemmapper.php
parent0fe7d8dd7ea1b61ff35cf071e7688332ac5d342e (diff)
fix a bug that would not display items of feeds without folders
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r--db/itemmapper.php5
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';
}