Replicas browser and optimizer
Yearwise edits of Project Pages
This query is marked as a draft
This query has been published
To be grouped at the closest leaf corresponding to project
use tewiki_p; SET @count:=0; SELECT (@count:=@count+1) AS sl_no, p.page_namespace as namespace, page_title as project_page, -- page_title as project_page, -- rev_timestamp LEFT(rev_timestamp,4) as edityear, COUNT(*) as Edits FROM page p INNER JOIN revision ON revision.rev_page = p.page_id WHERE p.page_title LIKE "వికీప్రాజెక్టు/%" and (p.page_namespace=4 or p.page_namespace=5) GROUP BY p.page_title, LEFT(rev_timestamp,4) HAVING Edits > 0 ORDER BY edityear DESC LIMIT 10000;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in