USE dewiki_p;

SELECT ut.user_name, ut.user_editcount, ipb.ipb_expiry, MID(ipb.ipb_reason,1,15)

, concat("tr.wikipedia.org/wiki/User:",replace(u.user_name," ","_")) as ltr

, ipb.ipb_timestamp, ipb.ipb_by_text

FROM ipblocks ipb join user u on u.user_id = ipb.ipb_user join trwiki_p.user ut on ut.user_name = u.user_name

left join trwiki_p.ipblocks dig on dig.ipb_user =  ut.user_id 

where ipb.ipb_user>0 and dig.ipb_user is NULL

order by ut.user_editcount desc, ipb.ipb_timestamp desc

;