Untitled query #79587

SQL

set
  max_statement_time = 300;

select
  actor_user,
  actor_name,
  r.rev_timestamp,
#  r.rev_actor,
#  r.rev_id,
#  r.rev_page,
  page_id,
  page_title
from
  # use actor_revision and revision_userindex views rather than actor and revision tables. 2 orders of magnitude faster
  actor_revision
  join revision_userindex as r on r.rev_actor = actor_id
  join page on page_id = r.rev_page
where
  page_namespace = 0
  and page_title = 'Israel–Hamas_war'
order by
  r.rev_timestamp
limit 10;

#select * from actor_revision limit 50
#select * from revision_userindex limit 50
#select * from revision limit 50
#select * from comment_revision limit 10
# user_id = actor_user = 45113768
# rev_actor = actor_id = 222965530
# actor_name = user_name = 'General Blorp'
# rev_comment_id = 19459854
SQL

Checking query status...
