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

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

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;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...