Cannabis Ruderalis

thcscience_admin

Noia 64 apps karm.svg This user has been on Wikipedia for 11 years, 7 months and 8 days.
♂This contributor to Wikipedia is male.
wuu箇个用户个母语是吴语。
箇個用戶個母語是吳語。
Chemin de ronde muraille long.JPGThis user is a member of
WikiProject China.
Supply and DemandThis user is a member of
WikiProject Economics
Wikitech-2021-logo-blue-without-wordmark.svgThis user has an account on Wikitech.
Table tennis.svgThis 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[edit]

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
source: https://web.archive.org/web/20220301204735/https://en.wikipedia.org/wiki/User:Normchou

Leave a Reply