All Louisville area-related articles

Fork of Editor Insight - Total recent subject page edits for specific user by StefenTower

This query is marked as a draft This query has been published by StefenTower.

This is a list of WikiProject-included mainspace pages, excluding redirects and disambiguation pages, thus genuine articles.

SQL

SELECT page_title AS subjectpagetitle, CONCAT('Talk:', page_title) AS talkpagetitle
FROM page_assessments_projects
JOIN page_assessments ON pa_project_id = pap_project_id AND pa_class NOT IN ('Disambig', 'Redirect')
JOIN page ON page_id = pa_page_id AND page_namespace = 0
WHERE pap_project_title = 'United States/WikiProject Louisville' -- substitute project name as coded in PageAssessments
ORDER BY page_title ASC;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...