Editor Count Odia Wikipedia

SQL

USE orwiki_p;
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;
SQL

Checking query status...
