creation date, for a set of pages with assessment on talkpage

SQL

SELECT
  page_title,
  actor_name,
  rev_timestamp as first_rev_timestamp,
  COUNT(*) as num_of_revisions
FROM actor
LEFT JOIN revision
      ON rev_actor = actor_id    
LEFT JOIN page
      ON page_id = rev_page
WHERE page_namespace=0 AND page_is_redirect =0 AND  rev_parent_id= 0 AND (page_title in (SELECT page_title 
                    FROM page
			LEFT JOIN  categorylinks ON categorylinks.cl_from = page.page_id
		WHERE (page_namespace=1 AND categorylinks.cl_to = 'B-Class_Andhra_Pradesh_articles')))
GROUP BY page_title
ORDER BY page_title,actor_name;

SQL

Checking query status...