Wikitrends-1 top edited pages

Wikitrend project statistics for phase 1,https://te.wikipedia.org/wiki/%E0%B0%B5%E0%B0%BF%E0%B0%95%E0%B1%80%E0%B0%AA%E0%B1%80%E0%B0%A1%E0%B0%BF%E0%B0%AF%E0%B0%BE_%E0%B0%9A%E0%B0%B0%E0%B1%8D%E0%B0%9A:%E0%B0%B5%E0%B0%BF%E0%B0%95%E0%B1%80%E0%B0%AA%E0%B1%8D%E0%B0%B0%E0%B0%BE%E0%B0%9C%E0%B1%86%E0%B0%95%E0%B1%8D%E0%B0%9F%E0%B1%81/%E0%B0%A8%E0%B0%BE%E0%B0%A3%E0%B1%8D%E0%B0%AF%E0%B0%A4%E0%B0%BE%E0%B0%AD%E0%B0%BF%E0%B0%B5%E0%B1%83%E0%B0%A6%E0%B1%8D%E0%B0%A7%E0%B0%BF-%E0%B0%B5%E0%B0%BF%E0%B0%95%E0%B1%80%E0%B0%9F%E0%B1%8D%E0%B0%B0%E0%B1%86%E0%B0%82%E0%B0%A1%E0%B1%8D%E0%B0%B8%E0%B1%8D_1

SQL

use tewiki_p;
SELECT  page_title,
COUNT(*) As Edits
FROM page
LEFT JOIN revision
ON revision.rev_page = page.page_id 
WHERE rev_timestamp >= '20140201000000'
AND rev_timestamp <'20140301000000'
AND page_namespace = 0
AND page_title in (SELECT page_title 
        FROM page
        JOIN categorylinks ON categorylinks.cl_from = page.page_id
        WHERE page.page_namespace = 1 AND categorylinks.cl_to= 'వికీప్రాజెక్టు_నాణ్యతాభివృద్ధి-వికీట్రెండ్స్_పేజీలు') 
GROUP BY page_title
HAVING Edits > 0
ORDER BY Edits DESC LIMIT 25;

SQL

Checking query status...