Maiores contribuidores de esporte da ptwiki nos últimos 12 meses

SQL

SELECT 
  count(*) as counter, 
  rev_actor,
  actor_name
FROM 
  revision
  left join actor on actor_id = rev_actor
where 
  rev_timestamp > '20230320020248' 
  and (
    rev_page = '1293001' 
    or rev_page = '82716' 
    or rev_page = '2186209' 
    or rev_page = '20233' 
    or rev_page = '198667' 
    or rev_page = '1611331' 
    or rev_page = '1858467' 
    or rev_page = '5378287' 
    or rev_page = '74853' 
    or rev_page = '366267' 
    or rev_page = '7163804' 
    or rev_page = '7049969' 
    or rev_page = '7207906' 
    or rev_page = '6999913' 
    or rev_page = '4887919' 
    or rev_page = '1346837' 
    or rev_page = '2122617' 
    or rev_page = '623142' 
    or rev_page = '6723924' 
    or rev_page = '7025641'
  ) 
group by 
  rev_actor 
order by 
  counter desc;

SQL

Checking query status...