user list samet yücel

SQL

select user_name, user_registration, user_editcount, ipb_address, ipb_expiry, ipb_sitewide

from user
left join ipblocks on user_name = ipb_address
where 1=1

 and (UPPER(CONVERT(user_name USING utf8mb4)) like '%SAMET%'
      OR UPPER(CONVERT(user_name USING utf8mb4)) like '%YÜCEL%'
     OR UPPER(CONVERT(user_name USING utf8mb4)) like '%HIKMET%'     )
 
-- and (user_editcount > 0 or ipb_address is not null)
-- and ipb_address is null
 and user_registration > 20220815000000
order by user_registration desc
limit 100
SQL

Checking query status...
