diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-02-22 12:01:53 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-02-22 12:01:53 +0100 |
| commit | 80ce2def461705ebd0853e99ddfc0d1bc1de2915 (patch) | |
| tree | f908c2a7ddec4f38e1b479e14e09ef85f14840de /Zotlabs/Module/Channel.php | |
| parent | a1f9d40d08de8cf126a7a519c6f040c4df5ed00c (diff) | |
| download | volse-hubzilla-80ce2def461705ebd0853e99ddfc0d1bc1de2915.tar.gz volse-hubzilla-80ce2def461705ebd0853e99ddfc0d1bc1de2915.tar.bz2 volse-hubzilla-80ce2def461705ebd0853e99ddfc0d1bc1de2915.zip | |
also sort by id to not make mysql change the queryplan if offset is > 0 after recent index changes
Diffstat (limited to 'Zotlabs/Module/Channel.php')
| -rw-r--r-- | Zotlabs/Module/Channel.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Zotlabs/Module/Channel.php b/Zotlabs/Module/Channel.php index 231146999..3d3eb2a85 100644 --- a/Zotlabs/Module/Channel.php +++ b/Zotlabs/Module/Channel.php @@ -255,7 +255,7 @@ class Channel extends \Zotlabs\Web\Controller { AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 $sql_extra $sql_extra2 - ORDER BY created DESC $pager_sql ", + ORDER BY created DESC, id $pager_sql ", intval(\App::$profile['profile_uid']) ); } |