unreviewed WikiProject Netherlands articles

SQL

SELECT DISTINCT article.page_title AS PT, CONCAT("https://en.wikipedia.org/wiki/", article.page_title) AS link

FROM page article
JOIN page talkpage ON article.page_title = talkpage.page_title
JOIN templatelinks ON talkpage.page_id=templatelinks.tl_from

WHERE article.page_id IN (
SELECT page.page_id
FROM revision 
JOIN pagetriage_page ON rev_page = ptrp_page_id 
JOIN page ON page_id = rev_page 
WHERE rev_parent_id = 0
AND ptrp_reviewed = 0
AND page_namespace = 0
AND page_is_redirect = 0
) 
AND article.page_namespace=0
AND talkpage.page_namespace= 1
AND templatelinks.tl_title IN ('WikiProject_Netherlands'
                              )

SQL

Checking query status...