Untitled query #79588

SQL

use enwiki_p;
set
  statement max_statement_time = 500 for
select
  u.user_id,
  u.user_name,
  u.user_registration,
  u.user_editcount,
  b.ipb_timestamp
from
  user u
  join ipblocks b on u.user_id = b.ipb_user
where
  u.user_id in (
    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...
