Artículos más revertidos en el último día

SQL

select rc_title, count(distinct rc_actor) as users, count(1) as editions, 
	min(rc_timestamp) as first_revert, max(rc_timestamp) as last_revert
from recentchanges 
inner join change_tag on ct_rc_id = rc_id 
inner join change_tag_def on ctd_id = ct_tag_id
inner join page on rc_cur_id = page_id
where ctd_id in (5,6)
	and page_namespace in (0, 100)
	and rc_timestamp between date_add(now(), INTERVAL -24 HOUR) and now()
group by 1
having editions >= 3
	and users >= 2
order by 2 desc
limit 10;

AخA
 
select rc_title, count(distinct rc_actor) as users, count(1) as editions,     min(rc_timestamp) as first_revert, max(rc_timestamp) as last_revertfrom recentchanges inner join change_tag on ct_rc_id = rc_id inner join change_tag_def on ctd_id = ct_tag_idinner join page on rc_cur_id = page_idwhere ctd_id in (5,6)    and page_namespace in (0, 100)    and rc_timestamp between date_add(now(), INTERVAL -24 HOUR) and now()group by 1having editions >= 3    and users >= 2order by 2 desclimit 10;

SQL

Checking query status...