Untitled query #79588

SQL

use enwiki_p;
set
  statement max_statement_time = 500 for
select
  u.user_id
from
  user u
  join ipblocks b on u.user_id = b.ipb_user
  join comment_ipblocks c on b.ipb_reason_id = c.comment_id
where
  u.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
  u.user_id
from
  user u
where
  u.user_name in (
    select
      p.page_title
    from
      categorylinks c
      join page p on c.cl_from = p.page_id
    where
      c.cl_to in (
        'Suspected_Wikipedia_sockpuppets_of_AndresHerutJaim',
        'Wikipedia_sockpuppets_of_AndresHerutJaim',
        'Suspected_Wikipedia_sockpuppets_of_Delotrooladoo',
        'Wikipedia_sockpuppets_of_Delotrooladoo'
      )
  )
order by
  u.user_id desc
SQL

Checking query status...
