USE zhwiki_p;

SELECT user_name, datediff(rev_timestamp, ipb_timestamp)*24+((rev_timestamp-ipb_timestamp)%1000000 DIV 10000)+((rev_timestamp-ipb_timestamp)%10000 DIV 100)/60 AS hour_diff FROM ipblocks, user, page, revision WHERE ipb_expiry="infinity" AND ipb_user=user_id AND page_namespace=2 AND page_title=REPLACE(user_name," ","_") AND rev_page=page_id AND rev_parent_id=0 AND rev_timestamp>ipb_timestamp AND ipb_timestamp>20180101000000;