Special:NewFiles: Make 'hidepatrolled' query less slow
authorBartosz Dziewoński <matma.rex@gmail.com>
Tue, 9 Feb 2016 12:46:31 +0000 (13:46 +0100)
committerBartosz Dziewoński <matma.rex@gmail.com>
Wed, 17 Feb 2016 16:14:44 +0000 (17:14 +0100)
commit211e5d05a0e1bc1b5bcb8aef6413f43032ba5529
tree14fae5f655f99f214cd1bcadd360dd06f3583aec
parenta592a76edffbc792fda134768cccc0f751b232fc
Special:NewFiles: Make 'hidepatrolled' query less slow

We're ordering by img_timestamp, so we have to make sure MariaDB
queries `image` first. It sometimes decides to query `recentchanges`
first and filesort the result set later to get the right ordering.
This is probably <https://mariadb.atlassian.net/browse/MDEV-8880>.

Also added missing 'rc_namespace' condition.

Bug: T124205
Change-Id: Iad7c96ed452907db3b425a1a53ea098528b4dc23
includes/specials/SpecialNewimages.php