From 3fa809ae7986d710912bb948d828eb35db75d910 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Sun, 11 Feb 2018 20:53:27 +0100 Subject: this might seem rediculous but it helps mysql to find the better index for this query --- include/items.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'include') 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') -- cgit v1.2.3