Fork of creation date, for a set of pages with assessment on talkpage by Arjunaraoc
This query is marked as a draft This query has been published by Arjunaraoc.

SQL

AخA
 
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...