1 week ago
5
minor SQL rewrite
| ← Previous revision | Revision as of 04:46, 5 July 2025 | ||
| Line 10: | Line 10: | ||
SELECT * |
SELECT * |
||
FROM page_assessments_projects |
FROM page_assessments_projects |
||
JOIN page_assessments ON pa_project_id = pap_project_id |
JOIN page_assessments ON pa_project_id = pap_project_id AND pa_class NOT IN ('Disambig', 'Redirect') |
||
JOIN revision ON rev_page = pa_page_id |
JOIN revision ON rev_page = pa_page_id AND rev_timestamp > (NOW() - INTERVAL 7 DAY) |
||
JOIN page ON page_id = rev_page |
JOIN page ON page_id = rev_page AND page_namespace = 0 |
||
WHERE pap_project_title = 'United States/WikiProject Louisville' -- substitute project name as coded in PageAssessments |
WHERE pap_project_title = 'United States/WikiProject Louisville' -- substitute project name as coded in PageAssessments |
||
AND rev_timestamp > (NOW() - INTERVAL 7 DAY) |
|||
AND page_namespace = 0 |
|||
AND pa_class NOT IN ('Disambig', 'Redirect') |
|||
) |
) |
||
SELECT COUNT(*) AS Edits, page_title AS Article, pa_class AS Rating |
SELECT COUNT(*) AS Edits, page_title AS Article, pa_class AS Rating |
||
