Page Menu
Home
Miraheze
Search
Configure Global Search
Log In
Paste
P151
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Paladox
on Dec 5 2018, 00:07.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Flag For Later
Award Token
Tags
None
Referenced Files
F871781:
Dec 5 2018, 00:07
2018-12-05 00:07:54 (UTC+0)
Subscribers
None
$res = $dbr->select(
$userTable,
[
'user_id',
'user_real_name',
'page_count',
'rev_count',
'wiki_rank' => 'page_count+SQRT(rev_count-page_count)*2',
],
[],
__METHOD__,
[
'ORDER BY' => 'wiki_rank DESC',
'LIMIT' => $limit,
],
"u JOIN (($sqlMostPages) UNION ($sqlMostRevs)) s ON (user_id=rev_user)"
);
Event Timeline
Paladox
created this paste.
Dec 5 2018, 00:07
2018-12-05 00:07:54 (UTC+0)
Log In to Comment