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 DAY) AND curdate()

group by 1

having contado > 4

order by 2 desc

limit 10;