Untitled query #89994

SQL

USE enwiki_p;
SELECT 
    CASE 
        WHEN ipb.ipb_id IS NOT NULL AND ipb.ipb_sitewide = 1 THEN 'blocked'
        WHEN ipb.ipb_id IS NOT NULL AND ipb.ipb_sitewide = 0 THEN 'partially-blocked'
        ELSE ''
    END AS block_status,
    CONCAT('Special:Contributions/', u.user_name) AS user_name,
    u.user_editcount,
    DATE_FORMAT(u.user_registration, '%d %M %Y') AS user_registration
FROM user u
LEFT JOIN ipblocks ipb ON u.user_id = ipb.ipb_user
WHERE 
    u.user_editcount IS NOT NULL 
    AND u.user_editcount > 0
    AND u.user_registration >= NOW() - INTERVAL 2 DAY
ORDER BY u.user_id DESC
LIMIT 500;
SQL

Checking query status...
