Maiores contribuidores de esporte da ptwiki nos últimos 12 meses

SQL

SELECT 
  count(rev_id) as Edits,
  actor_name as Editor, 
  rev_actor as ID
FROM 
  revision
  left join actor on actor_id = rev_actor
where 
  rev_timestamp > '20220918000000' 
  and (
    rev_page = '54638' 
    or rev_page = '5295820' 
    or rev_page = '3468785' 
    or rev_page = '3468785' 
    or rev_page = '390321' 
    or rev_page = '70111' 
    or rev_page = '6751925' 
    or rev_page = '7023736' 
    or rev_page = '216606' 
    or rev_page = '4578013' 
    or rev_page = '6150669' 
    or rev_page = '8915' 
    or rev_page = '5532' 
    or rev_page = '5893583' 
    or rev_page = '5893583' 
    or rev_page = '6508123' 
    or rev_page = '6787780' 
    or rev_page = '2222761' 
    or rev_page = '124357' 
    or rev_page = '2633349' 
    or rev_page = '6809923' 
    or rev_page = '51202' 
    or rev_page = '6157919' 
    or rev_page = '6492858' 
    or rev_page = '56997' 
    or rev_page = '20248' 
    or rev_page = '6997031' 
    or rev_page = '620' 
    or rev_page = '6502986' 
    or rev_page = '50218' 
    or rev_page = '2036460' 
    or rev_page = '20238' 
    or rev_page = '35597' 
    or rev_page = '1029385' 
    or rev_page = '791321' 
    or rev_page = '55063' 
    or rev_page = '4291735' 
    or rev_page = '3514085' 
    or rev_page = '297974' 
    or rev_page = '40612' 
    or rev_page = '6752302' 
    or rev_page = '872' 
    or rev_page = '7036297' 
    or rev_page = '20241' 
    or rev_page = '20233' 
    or rev_page = '6794847' 
    or rev_page = '982824' 
    or rev_page = '11469' 
    or rev_page = '6171024' 
    or rev_page = '1752' 
    or rev_page = '50228' 
  ) 
group by 
  rev_actor 
order by 
  Edits desc;
SQL

Checking query status...
