Number of tool aided editing by tags

SQL

use commonswiki_p;
select 
	ctd_name, 
    rc_source, 
    rc_namespace, 
    count(distinct(rc_id)) as change_count, 
    count(distinct(rc_cur_id)) as page_count,    
    count(distinct(rc_actor)) as user_count
from  
	change_tag_def as ctd, 
    change_tag as ct, 
    recentchanges as rc 
where 
	ctd.ctd_id=ct.ct_tag_id 
    and ct.ct_rc_id=rc_id 
    and ctd_name IN (
      "computer-aided-tagging-manual", 
      "computer-aided-tagging", 
      "HotCat", 
      "Cat-a-lot", 
      "OAuth CID: 1351", --quickstatements [1.0]
      "OAuth CID: 1776", --quickstatements [2.0]
      "OAuth CID: 1277", --QuickCategories [1.0]
      "ACDC",
      "OAuth CID: 378", --Widar [1.4]	Wikidata remote editor
      "OAuth CID: 1857", --Locator tool
      "OAuth CID: 496", --Locator tool
      "OAuth CID: 1702", --Wikidata Image Positions [1.2] 
      "OAuth CID: 1453", --Wikidata Image Positions [1.1]
	  "OAuth CID: 544", --Wikimaps warper
      "Short caption",
      "OAuth CID: 1349" --Nordic Museum Depicts [1.0]
    ) 
    and rc_namespace=6 
    and rc_source="mw.edit" 
group by ctd_name;
SQL

Checking query status...
