Ente Gramam 2016 Edit-A-thon Statistics of ML

SQL

# Quarry for extracting details about new articles created during Punjab Editathone 2016 as part of
# Wikimedia India Conference 2016 held at Chandigarh 5,6,7 August 2016
#Creator User:ViswaPrabha

#for Language ml

#USE bnwiki_p; # bn Bengali
#USE enwiki_p; # en English
#USE hiwiki_p; # hi Hindi
#USE knwiki_p; # kn Kannada
USE mlwiki_p; # ml Malayalam
#USE mrwiki_p; # mr Marathi
#USE orwiki_p; # or Oriya
#USE pawiki_p; # pa Punjabi
#USE sawiki_p; # sa Sanskrit
#USE sdwiki_p; # sd Sindhi
#USE tawiki_p; # ta Tamil
#USE tewiki_p; # te Telugu
#USE urwiki_p; # ur Urdu


SELECT

t.page_id AS PID,
r2.rev_id AS CreateRID,
r2.rev_timestamp AS CreateTime,
r2.rev_user_text AS Creator,
r1.rev_id AS LastRID,
r1.rev_timestamp AS LastTime,
r1.rev_user_text AS LastEditor,
r1.rev_len AS LastSize,
t.cnt AS Edits,
t.page_title AS Title


FROM ( 	
  	SELECT COUNT(*) AS cnt, r.rev_timestamp, p.page_id, p.page_title, p.page_latest, p.page_namespace
  	FROM revision r
	LEFT JOIN page p ON p.page_id = r.rev_page
	WHERE r.rev_page IN ( 
		SELECT page_id FROM page p2
    	WHERE p2.page_namespace = 0 AND p2.page_title IN (
		SELECT page_title FROM page
      	WHERE page_id IN ( 
			SELECT cl_from FROM categorylinks
      		WHERE
     cl_to = "2016_-ലെ_എന്റെ_ഗ്രാമം_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_സൃഷ്ടിക്കപ്പെട്ട_ലേഖനങ്ങൾ" 			#ml - The Category Name
        	) 
    	)
	)Participants who achieve 4 accepted articles will receive a Wikipedia Asian Month postcard. You will receive another special postcard if you achieve 15 accepted articles. The Wikipedian with the highest number of accepted articles on the Malayalam Wikipedia will be honored as a "Wikipedia Asian Ambassador", and will receive a signed certificate and additional postcard.
	AND p.page_namespace = 0
	GROUP BY page_namespace, page_title
) AS t
LEFT JOIN revision r2 ON r2.rev_page = t.page_id AND r2.rev_parent_id = 0
LEFT JOIN revision r1 ON r1.rev_id = t.page_latest
GROUP BY t.page_namespace, t.page_title order by r2.rev_timestamp asc;
SQL

Checking query status...
