Untitled query #79588

SQL

use enwiki_p;
set
  statement max_statement_time = 100 for
select count(*)
from
(
select
  u1.user_id
from
  user u1
  join ipblocks b on u1.user_id = b.ipb_user
  join comment_ipblocks c on b.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 u2
join page p on u2.user_name = p.page_title
join categorylinks 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'
      )
)
SQL

Checking query status...
