[15:53:21] brion (IRC) MaxSem RoanKattouw (IRC) o/ please excuse the random ping! We have unearthed a 14 year old fossil of a bug, T208909. The result was that page_random has poorly distributed values for ~10 months. I'm soliciting help wherever I can get it but I've heard that you three in particular would have the expertise to provide feedback on our fixer script proposal: [15:53:21] T208909: [Bug] Update old nonuniformly distributed page_random values - https://phabricator.wikimedia.org/T208909 [15:53:22] https://gerrit.wikimedia.org/r/#/c/mediawiki/core/+/472596/. My apologies for the distraction and thank you for any help you can give! [20:54:19] niedzielski: thanks, left a note. looks functional but i wanted to double-check why it's jumping through hoops to do timestamp-based revision lookups when i'm not sure it's needed [21:03:29] thank you brion (IRC) . can't tell you how much i appreciate you looking into it. will follow up shortly! [21:05:40] :D [21:06:19] and i see MaxSem has delivered too. thank you as well! [21:15:43] hey MaxSem , i'm sorry but i'm no where near as familiar with queries as you. are you highlighting the row count in the outer query?