Untitled query #15658

SQL

USE fawiki_p;
SELECT concat('2004 > ',sum(if(rev_timestamp between 20010101000000 and 20050101000000, 1, 0))),concat('2005 > ',sum(if(rev_timestamp between 20050101000000 and 20060101000000, 1, 0)))
,concat('2006 > ',sum(if(rev_timestamp between 20060101000000 and 20070101000000, 1, 0))),concat('2007 > ',sum(if(rev_timestamp between 20070101000000 and 20080101000000, 1, 0)))
,concat('2008 > ',sum(if(rev_timestamp between 20080101000000 and 20070101000000, 1, 0))),concat('2009 > ',sum(if(rev_timestamp between 20090101000000 and 20100101000000, 1, 0)))
,concat('2010 > ',sum(if(rev_timestamp between 20100101000000 and 20110101000000, 1, 0))),concat('2011 > ',sum(if(rev_timestamp between 20110101000000 and 20120101000000, 1, 0)))
,concat('2012 > ',sum(if(rev_timestamp between 20120101000000 and 20130101000000, 1, 0))),concat('2013 > ',sum(if(rev_timestamp between 20130101000000 and 20140101000000, 1, 0)))
,concat('2014 > ',sum(if(rev_timestamp between 20140101000000 and 20150101000000, 1, 0))),concat('2015 > ',sum(if(rev_timestamp between 20150101000000 and 20160101000000, 1, 0)))
,concat('2016 > ',sum(if(rev_timestamp between 20160101000000 and 20170101000000, 1, 0)))
FROM revision join page on page_id=rev_page and page_namespace=0 and rev_parent_id = 0 where
page_id IN (
        SELECT tl_from
        FROM templatelinks
        WHERE tl_title = "بدون_منبع"
            AND tl_namespace = 10);
SQL

Checking query status...
