LP Editors and Pages Created

SQL

#count LEARNING PATTERNS ideas created per month by community
SELECT EXTRACT(Year from DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')) as `year`, 
EXTRACT(Month from DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')) as `month`, COUNT(rev_id) AS ideas_created_by_Community 
FROM metawiki_p.revision r
INNER JOIN metawiki_p.page AS p
ON r.rev_page = p.page_id 
INNER JOIN metawiki_p.categorylinks AS cl 
ON p.page_id = cl.cl_from
WHERE p.page_namespace = 200
AND cl.cl_to IN ("Learning_patterns")
AND r.rev_user_text NOT LIKE "%(WMF)"
AND r.rev_user_text NOT IN ("Ijon", "Frank_Schulenburg", "Jtmorgan","SarahStierch","Wolliff","anasuyas","Chedasaurus","Ciphers","floorkoudijs","Janstee","jwild","kittycarmichael","Macruzbar","Msannakoval","Opinenow","Satihsu","Tighef","zhengan")
AND r.rev_parent_id = 0
GROUP BY `year`, `month`;
ORDER BY `year`, `month`;
SQL

Checking query status...
