Unreviewed articles sorted by date

SQL

# USE huwiki_p; -- deprecated
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
WHERE page1.page_namespace = 0
    AND page1.page_id NOT IN ( -- do not list pages which have at least one reviewed revision
         SELECT flaggedpages.fp_page_id
         FROM flaggedpages
         WHERE flaggedpages.fp_page_id = page1.page_id
       )
    AND page1.page_is_redirect = 0 # do not list redirects
GROUP BY page1.page_title
ORDER BY MIN(revision1.rev_timestamp) DESC;
SQL

Checking query status...
