Untitled query #79588

SQL

use enwiki_p;

set max_statement_time = 100;

select
  u.user_id,
  u.user_name,
  u.user_registration,
  u.user_editcount,
  b.ipb_timestamp
from
  user as u
join
(
    select u1.user_id
    from user as u1
    join ipblocks as b1 on u1.user_id = b1.ipb_user
    join comment_ipblocks c on b1.ipb_reason_id = c.comment_id
    where u1.user_id >= (select user_id from user where user_name = 'AndresHerutJaim')
    and (
        lower(convert(c.comment_text using latin1)) like '%andresherutjaim%'
        or lower(convert(c.comment_text using latin1)) like '%delotrooladoo%'
        or convert(c.comment_text using utf8mb4) like '%יניב הורון%'
    )
    union
    select u2.user_id
    from user as u2
    join page as p on u2.user_name = p.page_title
    join categorylinks as c on p.page_id = c.cl_from
    where c.cl_to in (
        'Suspected_Wikipedia_sockpuppets_of_AndresHerutJaim',
        'Wikipedia_sockpuppets_of_AndresHerutJaim',
        'Suspected_Wikipedia_sockpuppets_of_Delotrooladoo',
        'Wikipedia_sockpuppets_of_Delotrooladoo'
    )
) as user_union
on u.user_id = user_union.user_id;
left join ipblocks as b on u.user_id = b.ipb_user
left join ipblocks as b on user_union.user_id = b.ipb_user
SQL

Checking query status...
