SQL
x
SET @days_ago = 0; # не проверены более N дней
SET @namespace = 0; # пространство имён
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
AND page_namespace = @namespace
ORDER BY Days DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.