Edits of Pages of a main category's depth2 subcategories

Fork of Edits of Pages of a main category's depth2 subcategories by Arjunaraoc

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

SQL

SELECT
     LEFT(rev_timestamp,6) as yymm,
     COUNT(*) as edits
from page
JOIN revision on rev_page=page_id 
WHERE page_title in (
SELECT
     page_title
from page 
JOIN categorylinks cl
ON page_namespace = 0 -- main page
AND cl.cl_from = page_id
      AND cl.cl_to in (
SELECT
  page_title 
FROM page p
JOIN categorylinks cl
ON p.page_namespace = 14 -- Optional namespace check. 14 - categories, 6 - files
AND cl.cl_from = p.page_id
      AND cl.cl_to in (
   
SELECT
  page_title 
FROM page p
JOIN categorylinks cl
ON p.page_namespace = 14 -- Optional namespace check. 14 - categories, 6 - files
AND cl.cl_from = p.page_id
      AND cl.cl_to = "ఆంధ్ర_ప్రదేశ్_గ్రామాలు" -- Insert your category here.
      ) )
)
GROUP BY yymm
ORDER BY yymm
LIMIT 1000;

SQL

Checking query status...