34 $dbr = $this->dbProvider->getReplicaDatabase( false,
'vslow' );
36 $res = $dbr->newSelectQueryBuilder()
38 'rev_user_text' =>
'actor_rev_user.actor_name',
39 'lastedit' =>
'MAX(rev_timestamp)',
40 'count' =>
'COUNT(page_id)',
43 ->join(
'revision',
null,
'page_id=rev_page' )
44 ->join(
'actor',
'actor_rev_user',
'actor_rev_user.actor_id = rev_actor' )
46 'page_title' . $dbr->buildLike( $dbr->anyString(),
'/', $code ),
47 'page_namespace' => $this->options->get(
'TranslateMessageNamespaces' ),
49 ->groupBy(
'actor_rev_user.actor_name' )
51 ->caller( __METHOD__ )
55 foreach ( $res as $row ) {
58 self::USER_NAME => $row->rev_user_text,
59 self::USER_TRANSLATIONS => (int)$row->count,
60 self::USER_LAST_ACTIVITY => $row->lastedit,
76 $dbr = $this->dbProvider->getReplicaDatabase( false,
'vslow' );
78 $res = $dbr->newSelectQueryBuilder()
80 'rev_user_text' =>
'actor_rev_user.actor_name',
81 'lang' =>
'substring_index(page_title, \'/\', -1)',
82 'lastedit' =>
'MAX(rev_timestamp)',
83 'count' =>
'COUNT(page_id)',
86 ->join(
'revision',
null,
'page_id=rev_page' )
87 ->join(
'actor',
'actor_rev_user',
'actor_rev_user.actor_id = rev_actor' )
89 'page_title' . $dbr->buildLike( $dbr->anyString(),
'/', $dbr->anyString() ),
90 'page_namespace' => $this->options->get(
'TranslateMessageNamespaces' ),
92 ->groupBy( [
'lang',
'actor_rev_user.actor_name' ] )
94 ->caller( __METHOD__ )
98 foreach ( $res as $row ) {
100 $data[$row->lang][] = [
101 self::USER_NAME => $row->rev_user_text,
102 self::USER_TRANSLATIONS => (int)$row->count,
103 self::USER_LAST_ACTIVITY => $row->lastedit,