dewikt-Stimmberechtigung

Fork of dewikt-Stimmberechtigung by Udo T.

This query is marked as a draft This query has been published by Udo T..

dewikt-Stimmberechtigung ermitteln.

2 x <username> ersetzen und den Beginn der Abstimmung in den 2 Datumsfeldern.

ACHTUNG: Es ist die UTC-Zeit anzugeben.

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 = '<username>')
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 = '<username>')
and r.rev_timestamp <= (SELECT DATE_FORMAT(DATE_SUB('20241211100000', INTERVAL 1 MONTH), '%Y%m%d%H%i00'));

SQL

Checking query status...