User:Normchou

This user has beenon Wikipediafor13 years, 8 months and 27 days. ♂This contributor to Wikipedia ismale. wuuCá cá dụng hộ cáMẫu ngữThịNgô ngữ. Cá cá dụng hộ cáMẫu ngữThịNgô ngữ. This user is aparticipantin WikiProject China. This user is aparticipantinWikiProject Economics. This user hasan accountonWikitech. This user playstable tennis.

Normchouis a Wikipedian living in the United States. Since December 2020, he has beenworking on a projectthat utilizesBoW,POS tagging,sentiment,andGloVeandWord2vecembeddingsto identify hard-to-detect abnormal connections among Wikipedia accounts. The project will help withWP:SPIand enforcement againstWP:SOCK,especially in relation to accounts that evadeWP:CHK(e.g.,WP:SPAandWP:IPbehindWP:PROXY).

If you are really interested in learning more about Normchou, pleaseclick here.

Misc

To connect to the English Wikipedia replica:

$mysql--defaults-file=$HOME/replica.my.cnf-henwiki.analytics.db.svc.eqiad.wmflabsenwiki_p

To find out all article pages edited by a given user:

SELECT
DISTINCTp.page_title
FROM
revision_userindexASru
JOINactorASaONru.rev_actor=a.actor_id
JOINpageASpONru.rev_page=p.page_id
WHERE
a.actor_name='Normchou'
ANDp.page_namespace=0
ORDERBY
p.page_title;

To find out all users that edited at least one common article by a given user, sorted by the number of common articles edited:

SELECT
a.actor_name,
COUNT(DISTINCTru.rev_page)AScnt
FROM
revision_userindexASru
JOIN(
SELECT
DISTINCTru.rev_page
FROM
revision_userindexASru
JOINactorASaONru.rev_actor=a.actor_id
JOINpageASpONru.rev_page=p.page_id
WHERE
a.actor_name='Normchou'
ANDp.page_namespace=0
)ASsonru.rev_page=s.rev_page
JOINactorASaONru.rev_actor=a.actor_id
GROUPBY
a.actor_name
ORDERBY
cntDESC;

User page

User talk page

Suggestions