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, ipb_allow_usertalk as allow_usertalk
, ipb_create_account as create_account
, ipb_enable_autoblock as enable_autoblock, ipb_block_email as block_email
, user_editcount as ec, left(user_registration,8) as kayit

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 "ukla[^c]"
and lower(ipb_reason) not REGEXP "ukla$"
-- */
and user_editcount > 20
order by user_editcount desc

;
SQL

Checking query status...
