User:Normchou

Icon This user has been on Wikipedia for 15 years, 7 months and 19 days.
♂This contributor to Wikipedia is male.
wuu箇个用户个母语是吴语。
箇個用戶個母語是吳語。
This user is a participant in
WikiProject China.
This user participates in WikiProject Economics.
This user edits 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

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.