Stimmberechtigung @ de.wikt

SQL

select /* SLOW_OK */ count(*) from revision_userindex r, page p
where r.rev_actor = (select a.actor_id from actor_revision a
where a.actor_name = 'Auvajs')
and p.page_id = r.rev_page
and p.page_namespace = 0
and r.rev_timestamp <= '20241211100000'
and rownum() <= 150
union all
select /* SLOW_OK */ count(*) from revision_userindex r
where r.rev_actor = (select a.actor_id from actor_revision a
where a.actor_name = 'Auvajs')
and r.rev_timestamp <= (SELECT DATE_FORMAT(DATE_SUB('20241211100000', INTERVAL 1 MONTH), '%Y%m%d%H%i00'));
SQL

Checking query status...
