Untitled query #85626

SQL

SELECT 
CONCAT("https://uk.wikipedia.org/wiki/",
       CASE page_namespace WHEN 14 THEN CONCAT("Категорія:", page_title)
                    WHEN 10 THEN CONCAT("Шаблон:", page_title)
                    WHEN 828 THEN CONCAT("Модуль:", page_title)
                    WHEN 6 THEN CONCAT("Файл:", page_title)
                    WHEN 100 THEN CONCAT("Портал:", page_title)
                    ELSE page_title
       END) AS Title
FROM flaggedpages
JOIN page ON fp_page_id = page_id
WHERE fp_reviewed = 0
AND (
  SELECT COUNT(*) FROM revision WHERE rev_page = fp_page_id AND rev_id > fp_stable) > 0
AND (
  SELECT COUNT(*) FROM revision WHERE rev_page = fp_page_id AND rev_id > fp_stable) =
  (
  SELECT COUNT(DISTINCT rev_id) FROM revision
  JOIN actor ON actor_id = rev_actor
  JOIN user_groups ON actor_user = ug_user
  WHERE rev_page = fp_page_id AND rev_id > fp_stable
    AND (ug_group = "bot" OR ug_group = "autoreview" OR ug_group = "editor" OR ug_group = "sysop"))
SQL

Checking query status...
