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 where
page_id IN (
        SELECT tl_from
        FROM templatelinks
        WHERE tl_title = "بدون_منبع"
            AND tl_namespace = 10);
SQL

Checking query status...
