use eswiki_p;

select rc_title, count(1) as contado 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(curdate(), INTERVAL -1 HOUR) AND curdate()

group by 1

having contado >= 3

order by 2 desc

limit 10;

​

select rc_title, count(1) as contado 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 ct_tag_id in (5,6)

and page_namespace in (0, 100)

and rc_timestamp between date_add(curdate(), INTERVAL -1 HOUR) AND curdate()

group by 1

having contado >= 3

-- order by 2 desc

-- limit 10;