SQL
AخA
SELECT
page.page_title AS `Article`,
CONCAT('Draft:', draft.page_title) AS `Draft`
FROM
pagetriage_page
JOIN page ON ptrp_page_id = page_id
JOIN (
SELECT
page_title
FROM
page
WHERE
page_namespace = 118
AND page_is_redirect = 0
) draft ON page.page_title = draft.page_title
WHERE
ptrp_reviewed = 0
AND page_namespace = 0
AND page_is_redirect = 0;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.