Page MenuHomeMiraheze
Paste P151

(An Untitled Masterwork)
ActivePublic

Authored by Paladox on Dec 5 2018, 00:07.
Tags
None
Referenced Files
F871781:
Dec 5 2018, 00:07
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