// Run the following line of code, and wait for the script to load:
mw.loader.load("https://en.wikipedia.org/w/index.php?action=raw&ctype=text/javascript&title=MediaWiki:Gadget-morebits.js");

// Then run the following, and wait for it to complete:
var query = {
	action:'query',
	list:'iwbacklinks',
	iwbltitle:'WP:FTCG',
	iwblprefix:'en',
	iwbllimit:'500',
	rawcontinue:''
};
var count = 0;
var iterations = 0;
var recurse = function(apiobj) {
	iterations++;
	count += $(apiobj.getXML()).find("iw").length;
	console.log("iteration " + iterations + ", count = " + count);
	var cont = $(apiobj.getXML()).find("query-continue iwbacklinks").attr("iwblcontinue");
	if (cont) {
		query.iwblcontinue = cont;
		mwapi = new Morebits.wiki.api("doing it", query, recurse);
		mwapi.post();
	} else {
		console.log("https://commons.wikimedia.org/w/api.php?" + Morebits.queryString.create(query));
	}
};
var mwapi = new Morebits.wiki.api("doing it", query, recurse);
mwapi.post();

select
    count(*) as `num`,
    left(rev_timestamp, 6) as `year_month`
from revision
join revision_comment_temp on revcomment_rev=rev_id
join comment on comment_id=revcomment_comment_id
join change_tag on ct_rev_id = rev_id
join change_tag_def on ct_tag_id = ctd_id
where
    ctd_name = 'OAuth CID: 67' -- OAuth Uploader
    and comment_text like '%#commonshelper%'
group by
    left(rev_timestamp, 6);

select
    count(*) as `num`,
    left(rev_timestamp, 6) as `year_month`
from iwlinks
join page on iwl_from = page_id
join revision on page_id = rev_page
where
iwl_prefix='en'
and iwl_title='WP:FTCG'
and (rev_parent_id is null or rev_parent_id = 0)
group by
    left(rev_timestamp, 6);

select
    count(*) as `num`,
    left(rev_timestamp, 6) as `year_month`
from categorylinks
join page on cl_from = page_id
join revision on page_id = rev_page
where
cl_to = 'Uploaded_with_MTC!'
and (rev_parent_id is null or rev_parent_id = 0)
group by
    left(rev_timestamp, 6);

select
    count(*) as `num`,
    left(rev_timestamp, 6) as `year_month`
from templatelinks
join page on tl_from = page_id
join revision on page_id = rev_page
where
tl_from_namespace = 6 -- NS_FILE
and tl_namespace = 10 -- NS_TEMPLATE
and tl_title = 'Original_upload_log'
and (rev_parent_id is null or rev_parent_id = 0)
group by
    left(rev_timestamp, 6);