aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2018-02-11 20:53:27 +0100
committerMario Vavti <mario@mariovavti.com>2018-02-11 20:53:27 +0100
commit3fa809ae7986d710912bb948d828eb35db75d910 (patch)
tree11f03c8754ef25b11abfb6d2b942df9ecee5cceb
parent6cc32943954124739023751eb377d398a54772d9 (diff)
downloadvolse-hubzilla-3fa809ae7986d710912bb948d828eb35db75d910.tar.gz
volse-hubzilla-3fa809ae7986d710912bb948d828eb35db75d910.tar.bz2
volse-hubzilla-3fa809ae7986d710912bb948d828eb35db75d910.zip
this might seem rediculous but it helps mysql to find the better index for this query
-rwxr-xr-xinclude/items.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/include/items.php b/include/items.php
index c7206458e..8091252d6 100755
--- a/include/items.php
+++ b/include/items.php
@@ -3467,7 +3467,7 @@ function item_expire($uid,$days) {
AND item_thread_top = 1
AND resource_type = ''
AND item_starred = 0
- $sql_extra $item_normal LIMIT $expire_limit ",
+ $sql_extra $item_normal ORDER BY created ASC LIMIT $expire_limit ",
intval($uid),
db_utcnow(),
db_quoteinterval(intval($days).' DAY')