Stats for Wikidata imports and migration under #COH

SQL

SELECT
	COUNT(DISTINCT(r.rev_page)) as num_pages,
    COUNT(DISTINCT(r.rev_id)) as num_edits,
    SUM(ABS(CAST(r.rev_len as SIGNED)-CAST(r_prev.rev_len as SIGNED))) as abs_diff_byte,
    SUM(ABS(CAST(r.rev_len as SIGNED)-CAST(r_prev.rev_len as SIGNED)))/1048576 as abs_diff_MB
FROM wikidatawiki_p.revision r
JOIN wikidatawiki_p.revision r_prev
	ON r.rev_parent_id = r_prev.rev_id
WHERE r.rev_timestamp > '20170101000001'
AND r.rev_timestamp < '20171215235959'
AND r.rev_user_text IN ('AndreCostaWMSE-bot', 'AliciaFagervingWMSE-bot')
AND r.rev_comment LIKE '%#COH%'
AND r.rev_page != 4246474 # Sandbox (Q4115189)

SQL

Checking query status...