Unreviewed articles sorted by date

SQL

# USE huwiki_p; -- deprecated
SELECT CONCAT('[[',page1.page_title,']]') AS 'Cím', 
CONCAT('[https://hu.wikipedia.org/w/index.php?title=',page1.page_title,'&action=history történet]') AS 'Történet', 
CONCAT('[https://hu.wikipedia.org/w/index.php?title=',page1.page_title,'&oldid=',page1.page_latest,' ellenőriz]') AS 'Ellenőriz',
GROUP_CONCAT(DISTINCT actor1.actor_name SEPARATOR ', ') AS 'Szerkesztők'
FROM page as page1 #, user_groups
INNER JOIN revision AS revision1 ON page1.page_id = revision1.rev_page
INNER JOIN actor AS actor1 ON revision1.rev_actor = actor1.actor_id
INNER JOIN logging ON (actor1.actor_id=logging.log_actor) 
INNER JOIN user AS user1 ON actor1.actor_user = user1.user_id
LEFT OUTER JOIN user_groups AS user_groups1 ON ug_user = actor_user
WHERE page1.page_namespace = 0
	AND log_action = "create" -- only list new pages
    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
       )
GROUP BY page1.page_title
ORDER BY revision1.rev_timestamp DESC;
SQL

Checking query status...
