Number of pages with ArbCom Ds/talk_notice by case

Fork of Pages with ArbCom Ds/talk_notice by case by AntiCompositeNumber

This query is marked as a draft This query has been published by AntiCompositeNumber.

SQL

USE enwiki_p;
SELECT REGEXP_REPLACE(pl_title, "Arbitration/Requests/Case/|Requests_for_arbitration/", "") as `case`, COUNT(*)
FROM page
JOIN templatelinks ON tl_from = page_id
JOIN pagelinks ON pl_from = page_id
WHERE 
	tl_title = "Ds/talk_notice"
	AND tl_namespace = 10
	AND page_namespace = 1
	AND pl_namespace = 4
	AND (
  		pl_title LIKE "Arbitration/Requests/Case/%" 
		OR pl_title LIKE "Requests_for_arbitration/%"
    )
GROUP BY REGEXP_REPLACE(pl_title, "Arbitration/Requests/Case/|Requests_for_arbitration/", "") WITH ROLLUP

SQL

Checking query status...