unreviewed new pages that exist as draft

SQL

SELECT pageA.page_title
FROM page AS pageD, page AS pageA JOIN pagetriage_page ON pageA.page_id = ptrp_page_id
JOIN revision AS revisionA ON pageA.page_id = revisionA.rev_page 
JOIN revision AS revisionD ON pageD.page_id = revisionD.rev_page 
WHERE revisionA.rev_user = revisionD.rev_user
AND revisionA.rev_parent_id = 0
AND pageA.page_namespace = 0 
AND pageD.page_namespace = 118
AND pageA.page_title = pageD.page_title
AND pageA.page_is_redirect = 0
AND pageD.page_is_redirect = 0
AND ptrp_reviewed = 0
#AND pageA.page_is_new = 1
AND ptrp_created > (NOW() - INTERVAL 30 DAY)
LIMIT 10;

SQL

Checking query status...