Contributor Count German Wikipedia 2016_v1

Fork of Contributor Count German Wikipedia 2016_v1 by Verena Lindner (WMDE)

This query is marked as a draft This query has been published by Jan Dittrich (WMDE).

A query to find out how many people: created a new account and as well reached 10 edits in a certain time

SQL

USE dewiki_p; -- German Wikipedia 
SELECT user_id, user_editcount -- user_id "is the primary key, used to uniquely identify a user"; editcount counts edits since account creation  
FROM user -- table user https://www.mediawiki.org/wiki/Manual:User_table
INNER JOIN revision -- join table "user" with table "revision", but only rows in which that (ON) is the case. Also, JOIN = INNER JOIN
ON user_id = revision.rev_user; 
LIMIT 5

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...