Untitled query #82030

SQL

SET @days_ago = 0;
SET @namespace = 0;
SET @lmt = 100;

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 @days_ago DAY  # не проверены более N дней
AND page_namespace = @namespace  # пространстов имён
ORDER BY Days DESC
LIMIT @lmt; # лимит на выдачу, если полная не нужна
SQL

Checking query status...
