USE dewiki_p;

SELECT ut.user_name, ut.user_editcount as ec, MID(ipb.ipb_reason,1,25)

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

, ut.user_touched, ipb.ipb_expiry as ie, 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

#and ut.user_editcount>0

order by ut.user_editcount desc, ipb.ipb_timestamp desc

;