User:Normchou

This user has been on Wikipedia for 14 years and 18 days. ♂This contributor to Wikipedia is male. wuu箇个用户个母语是吴语。 箇個用戶個母語是吳語。 This user is a participant in WikiProject China. This user is a participant in WikiProject Economics. This user has an account on Wikitech. This user plays table tennis.

Normchou is a Wikipedian living in the United States. Since December 2020, he has been working on a project that utilizes BoW, POS tagging, sentiment, and GloVe and Word2vec embeddings to identify hard-to-detect abnormal connections among Wikipedia accounts. The project will help with WP:SPI and enforcement against WP:SOCK, especially in relation to accounts that evade WP:CHK (e.g., WP:SPA and WP:IP behind WP:PROXY).

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

Misc

To connect to the English Wikipedia replica:

$ mysql --defaults-file=$HOME/replica.my.cnf -h enwiki.analytics.db.svc.eqiad.wmflabs enwiki_p

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

SELECT 
  DISTINCT p.page_title 
FROM 
  revision_userindex AS ru 
  JOIN actor AS a ON ru.rev_actor = a.actor_id 
  JOIN page AS p ON ru.rev_page = p.page_id 
WHERE 
  a.actor_name = 'Normchou' 
  AND p.page_namespace = 0 
ORDER BY 
  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(DISTINCT ru.rev_page) AS cnt 
FROM 
  revision_userindex AS ru 
  JOIN (
    SELECT 
      DISTINCT ru.rev_page 
    FROM 
      revision_userindex AS ru 
      JOIN actor AS a ON ru.rev_actor = a.actor_id 
      JOIN page AS p ON ru.rev_page = p.page_id 
    WHERE 
      a.actor_name = 'Normchou' 
      AND p.page_namespace = 0
  ) AS s on ru.rev_page = s.rev_page 
  JOIN actor AS a ON ru.rev_actor = a.actor_id 
GROUP BY 
  a.actor_name 
ORDER BY 
  cnt DESC;

User page

User talk page

Suggestions