diff options
| author | Mario <mario@mariovavti.com> | 2025-06-13 08:05:05 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2025-06-13 08:05:05 +0000 |
| commit | 2046abf26f0bcf55ac88f8a42f35bdf49be4ca98 (patch) | |
| tree | 90b83f2c42b019a73739249404579d6d8df197ff /include | |
| parent | ad7871270c415772a8a058cf65de81eed8886b43 (diff) | |
| download | volse-hubzilla-2046abf26f0bcf55ac88f8a42f35bdf49be4ca98.tar.gz volse-hubzilla-2046abf26f0bcf55ac88f8a42f35bdf49be4ca98.tar.bz2 volse-hubzilla-2046abf26f0bcf55ac88f8a42f35bdf49be4ca98.zip | |
trick sql to use a better suited index
Diffstat (limited to 'include')
| -rw-r--r-- | include/items.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/include/items.php b/include/items.php index e4aff1172..4eda9a221 100644 --- a/include/items.php +++ b/include/items.php @@ -5604,7 +5604,7 @@ function items_by_thr_parent(string $mid, int $parent, int|null $offset = null): $order_sql = "ORDER BY item.created"; if (isset($offset)) { - $order_sql = "ORDER BY item.created DESC LIMIT 3 OFFSET $offset"; + $order_sql = "ORDER BY item.created DESC, item.received DESC LIMIT 3 OFFSET $offset"; } $owner_uid = intval($parent_item[0]['uid']); |