diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-02-15 19:24:15 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-02-15 19:24:15 +0100 |
| commit | 9e251a1abcc50af0f678a17d3a688f4ba9e4a4fc (patch) | |
| tree | cd58fb823f3b9019c2e69f533027eaedcd9cc208 /Zotlabs/Module/Channel.php | |
| parent | 45b42cbc1c5356da61923f5bc2fbca1cec9f9119 (diff) | |
| download | volse-hubzilla-9e251a1abcc50af0f678a17d3a688f4ba9e4a4fc.tar.gz volse-hubzilla-9e251a1abcc50af0f678a17d3a688f4ba9e4a4fc.tar.bz2 volse-hubzilla-9e251a1abcc50af0f678a17d3a688f4ba9e4a4fc.zip | |
some more DB tuning.
Diffstat (limited to 'Zotlabs/Module/Channel.php')
| -rw-r--r-- | Zotlabs/Module/Channel.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/Zotlabs/Module/Channel.php b/Zotlabs/Module/Channel.php index 3dab85410..231146999 100644 --- a/Zotlabs/Module/Channel.php +++ b/Zotlabs/Module/Channel.php @@ -251,9 +251,9 @@ class Channel extends \Zotlabs\Web\Controller { else { $r = q("SELECT item.parent AS item_id FROM item left join abook on ( item.author_xchan = abook.abook_xchan $abook_uids ) - WHERE true and uid = %d $item_normal + WHERE true and item.uid = %d AND item.item_thread_top = 1 $item_normal AND (abook.abook_blocked = 0 or abook.abook_flags is null) - AND item.item_wall = 1 AND item.item_thread_top = 1 + AND item.item_wall = 1 $sql_extra $sql_extra2 ORDER BY created DESC $pager_sql ", intval(\App::$profile['profile_uid']) |