WikiTrends-1 Top Contributors

SQL

use tewiki_p;
SELECT
  user_name,
  COUNT(*) As Edits
FROM user
LEFT JOIN revision
      ON rev_user = user_id
LEFT JOIN page
      ON page_id = rev_page 
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 user_name
HAVING COUNT(*) > 0
ORDER BY Edits DESC LIMIT 25;
SQL

Checking query status...
