Pages unreviewed for longest time (huwiki)

SQL

use huwiki_p;

SELECT
	CONCAT(namespace_prefix, page_title) AS `cím`, # title
    CONCAT('https://hu.wikipedia.org/w/index.php?curid=', page_id) AS url,
    DATEDIFF(NOW(), created) as `ennyi napja ellenőrizetlen` # days_unreviewed
FROM
  (
    SELECT
      CASE page_namespace
          WHEN 0 THEN ''
          WHEN 6 THEN 'Fájl:'
          WHEN 10 THEN 'Sablon:'
          WHEN 14 THEN 'Kategória:'
          WHEN 100 THEN 'Portál:'
          WHEN 828 THEN 'Modul:'
      END AS namespace_prefix,
      page_namespace, page_title, page_id,
      STR_TO_DATE(MIN(rev_timestamp), '%Y%m%d%h%i%s') AS created
  	FROM
      page
      JOIN revision ON rev_page = page_id
      LEFT JOIN flaggedpages ON fp_page_id = page_id
  	WHERE
      fp_page_id IS NULL
      AND page_namespace IN (0, 6, 10, 14, 100, 828)
      AND page_is_redirect = 0
  	GROUP BY page_id
  	ORDER BY created ASC
  	LIMIT 5000
  ) tmp
;
SQL

Checking query status...
