Untitled query #84975

SQL

SELECT REPLACE(page_title, "_", " ") AS Title, DATEDIFF(TIMESTAMP(NOW()), fp_pending_since) AS Days,
(SELECT cl_type FROM categorylinks WHERE cl_from = page_id AND cl_to = "Википедия:Хорошие_статьи_по_алфавиту") AS Good,
(SELECT cl_type FROM categorylinks WHERE cl_from = page_id AND cl_to = "Википедия:Избранные_списки_и_порталы") AS FLP,
(SELECT cl_type FROM categorylinks WHERE cl_from = page_id AND cl_to = "Википедия:Избранные_статьи_по_алфавиту") AS Featured,
(SELECT pr_level FROM page_restrictions WHERE pr_page = page_id AND pr_type = "edit") AS Protected,
(SELECT COUNT(*) FROM revision WHERE rev_page = page_id AND rev_timestamp >= fp_pending_since) AS Revisions
FROM flaggedpages 
JOIN flaggedpage_config ON fpc_page_id = fp_page_id
JOIN page ON page_id = fpc_page_id
WHERE fp_pending_since is not null AND fp_pending_since <= NOW() - INTERVAL 0 DAY
AND page_namespace = 0
ORDER BY revisions DESC;
SQL

Checking query status...
