unreviewed new pages that exist as draft

SQL

SELECT pageA.page_title
FROM page AS pageA JOIN pagetriage_page ON pageA.page_id = ptrp_page_id
JOIN revision AS revisionA ON pageA.page_id = revision.rev_page 
JOIN revision AS revisionDON pageD.page_id = revision.rev_page ,
page AS pageD  
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...