unreferenced, reviewed articles

SQL

SELECT article.page_title, revision.rev_timestamp
FROM page AS article
JOIN page AS talk ON article.page_title = talk.page_title
JOIN templatelinks  ON tl_from = talk.page_id 
JOIN revision ON article.page_latest = rev_id
#WHERE article.page_id IN (1, 2, 3, 100, 844, 845, 846, 847, 848, 900, 901, 1000, 1200, 13000, 2345634)
#article.page_title IN ('Piet Mondrian')
WHERE tl_title = 'WikiProject_Visual_arts'
AND tl_from_namespace = 1
AND article.page_namespace = 0
AND talk.page_namespace = 1
ORDER BY revision.rev_timestamp ASC
LIMIT 10;

SQL

Checking query status...