Number of tool aided editing by tags

SQL

use commonswiki_p;
select 
	replace(
	replace(
      replace(
      replace(ctd_name, "OAuth CID: 1702", "Wikidata Image Positions),
              "OAuth CID: 1776", "quickstatements 2"),
              "OAuth CID: 1857", "Locator tool"),
              "OAuth CID: 544", "Wikimaps Warper")  
             ) as ctd_title 
    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...
