unreviewed new pages that exist as draft

SQL

SELECT pageA.page_title, revisionA.rev_id
FROM page AS pageD JOIN page AS pageA JOIN pagetriage_page ON pageA.page_id = ptrp_page_id
JOIN revision AS revisionA ON revisionA.rev_page = pageA.page_id
JOIN revision AS revisionD ON revisionD.rev_page = pageD.page_id
WHERE revisionA.rev_user = revisionD.rev_user
AND revisionA.rev_parent_id = 0
AND revisionD.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);
SQL

Checking query status...
