category addition date for a set of pages with assessment on talkpage

SQL

SELECT page_title, cl_timestamp 
FROM page
LEFT JOIN  categorylinks ON categorylinks.cl_from = page.page_id 
WHERE (page_namespace=1 AND categorylinks.cl_to = 'WikiProject_Andhra_Pradesh_articles' AND cl_type='page') 
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' OR categorylinks.cl_to = 'GA-Class_Andhra_Pradesh_articles') AND cl_type='page' )))
ORDER BY page_title;

SQL

Checking query status...