suresiz eski - Quarry

SQL

USE trwiki_p;
set @N = -1096;

select ipb_address as engellenen, left(ipb_timestamp,8) as tarih, ipb_by_text as engelleyen
, ipb_reason as sebep
, user_editcount as ec, left(user_registration,8) as kayit
, concat(ipb_allow_usertalk, ipb_create_account, ipb_enable_autoblock, ipb_block_email) as usertalk_createaccount_autoblock_blockemail

from ipblocks
join user on user_id = ipb_user

where ipb_user > 0
and ipb_expiry = "infinity"
and ipb_timestamp < date_add(now(), INTERVAL @N DAY)
and lower(ipb_reason) not rlike "ullanıcı *ad"
and upper(ipb_reason) not REGEXP "EP[^\d]*9.*$"
and lower(ipb_reason) not REGEXP "\#?1[34] *.? *[Kk]ukla *$"
/*and lower(ipb_reason) not REGEXP "ukla[^c]"
and lower(ipb_reason) not REGEXP "ukla$"
-- */
and user_editcount > 300
order by ipb_timestamp

;
SQL

Checking query status...
