USE tewiki_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('User:', REPLACE(u.user_name,' ','_')) AS user_name, 

    u.user_editcount, 

    DATE_FORMAT(u.user_registration, '%d %M %Y %H:%i') 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 100;