Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Stefan Schneider (WMDE)
.
Toggle Highlighting
SQL
USE dewiki_p; SELECT count(*) AS Dec2016 FROM user WHERE user_registration < 20180101000000; SELECT count(*) AS Dec2016 FROM user WHERE user_registration < 20170101000000; SELECT count(*) AS Dec2015 FROM user WHERE user_registration < 20160101000000; SELECT count(*) AS Dec2014 FROM user WHERE user_registration < 20150101000000; SELECT count(*) AS Dec2013 FROM user WHERE user_registration < 20140101000000; SELECT count(*) AS Dec2012 FROM user WHERE user_registration < 20130101000000; SELECT count(*) AS Dec2011 FROM user WHERE user_registration < 20120101000000; SELECT count(*) AS Dec2010 FROM user WHERE user_registration < 20110101000000; SELECT count(*) AS Dec2009 FROM user WHERE user_registration < 20100101000000; SELECT count(*) AS Dec2008 FROM user WHERE user_registration < 20090101000000; SELECT count(*) AS Dec2007 FROM user WHERE user_registration < 20080101000000; SELECT count(*) AS Dec2006 FROM user WHERE user_registration < 20070101000000; SELECT count(*) AS Dec2005 FROM user WHERE user_registration < 20060101000000; SELECT count(*) AS Dec2004 FROM user WHERE user_registration < 20050101000000; SELECT count(*) AS Dec2003 FROM user WHERE user_registration < 20040101000000;
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
.
Checking query status...