aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2018-02-22 12:01:53 +0100
committerMario Vavti <mario@mariovavti.com>2018-02-22 12:01:53 +0100
commit80ce2def461705ebd0853e99ddfc0d1bc1de2915 (patch)
treef908c2a7ddec4f38e1b479e14e09ef85f14840de
parenta1f9d40d08de8cf126a7a519c6f040c4df5ed00c (diff)
downloadvolse-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
-rw-r--r--Zotlabs/Module/Channel.php2
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'])
);
}