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;