Untitled query #82030

SQL

DECLARE @days_ago Int, @namespace Int, @max_limit Int;
SET @days_ago = 0;
SET @namespace = 0;
SET @max_limit = 10000;

SELECT page_title AS Title, DATEDIFF(TIMESTAMP(NOW()), fpp_pending_since) AS Days FROM flaggedpage_pending 
JOIN flaggedpage_config ON fpc_page_id = fpp_page_id
JOIN page ON page_id = fpc_page_id
WHERE fpp_pending_since <= NOW() - INTERVAL @fays_ago DAY  # не проверены более N дней
AND page_namespace = 0  # пространстов имён
ORDER BY Days DESC
# LIMIT 100  # лимит на выдачу, если полная не нужна
SQL

Checking query status...
