Unreviewed articles sorted by date

SQL

SELECT CONCAT('[[',page1.page_title,']]') AS 'Cím', MIN(revision1.rev_timestamp)
FROM page as page1
INNER JOIN revision AS revision1 ON page1.page_id = revision1.rev_page # first revision
LEFT OUTER JOIN flaggedpages ON flaggedpages.fp_page_id = page1.page_id
WHERE page1.page_namespace = 0
    AND flaggedpages.fp_page_id IS NULL # do not list pages which have at least one reviewed revision
    AND page1.page_is_redirect = 0 # do not list redirects
GROUP BY page1.page_title
ORDER BY MIN(revision1.rev_timestamp) DESC LIMIT 500;

SQL

Checking query status...