USE zhwiki_p;

SELECT ipb_timestamp, REPLACE(ipb_address, " ", "_") AS `username`, page_id, pt_timestamp

FROM ipblocks

LEFT JOIN page ON REPLACE(ipb_address, " ", "_") = page_title AND page_namespace = 2

LEFT JOIN protected_titles ON REPLACE(ipb_address, " ", "_") = pt_title AND pt_namespace = 2

WHERE ipb_user != 0

    AND ipb_expiry = 'infinity'

    AND page_id IS NULL

    AND pt_timestamp IS NULL

ORDER BY ipb_id DESC 

# LIMIT 10