Untitled query #79587

SQL

set
  max_statement_time = 300;

select * from actor_revision limit 200
#select *
# from
# (
# select
#   actor_user,
#   actor_name,
#   r1.rev_timestamp,
#   r1.rev_actor,
#   r1.rev_id,
#   r1.rev_page,
#   page_id,
#   page_title,
#   row_number() over (partition by actor_id order by r1.rev_timestamp desc) as n
# from
#   # use actor_revision and revision_userindex views rather than actor and revision tables. 2 orders of magnitude faster
#   actor
#   join revision_userindex as r1 on r1.rev_actor = actor_id
#   join page on page_id = r1.rev_page
# where
#   # random-ish sampling of blocked socks and none-socks/active editors
#   actor_name in ("General Blorp","Aroma Stylish","SoaringLL","LeMamba","Emolu","Ecrusized","Irtapil","JM2023","NadVolum","Yorkporter")
# order by
#   actor_user, r1.rev_timestamp
# ) as revs
# where n <= 600
#limit 600;

#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...
