diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-02-11 20:53:27 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-02-11 20:53:27 +0100 |
| commit | 3fa809ae7986d710912bb948d828eb35db75d910 (patch) | |
| tree | 11f03c8754ef25b11abfb6d2b942df9ecee5cceb | |
| parent | 6cc32943954124739023751eb377d398a54772d9 (diff) | |
| download | volse-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-x | include/items.php | 2 |
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') |