A test query to fix a tool

SQL

    SELECT count(r1.rev_id) as cnt, r1.rev_page, r1.rev_timestamp, p1.page_id, p1.page_title, p1.page_latest, p1.page_namespace
  	FROM revision r1
	LEFT JOIN page p1 ON p1.page_id = r1.rev_page
	WHERE r1.rev_page IN ( 
		SELECT page_id FROM page p2
    	WHERE p2.page_namespace = 0 AND p2.page_title IN (
          	   SELECT pg.page_title FROM page pg
               left join categorylinks cl on cl.cl_from=pg.page_id 
          	   WHERE cl.cl_to = "2017-ലെ_വനിതാദിന_തിരുത്തൽ_യജ്ഞത്തിന്റെ_ഭാഗമായി_സൃഷ്ടിക്കപ്പെട്ട_ലേഖനങ്ങൾ" 	#ml - The Category Name
           )
		)
   AND p1.page_namespace = 0
	GROUP BY  p1.page_title
    Limit 10
SQL

Checking query status...
