Untitled query #49066

SQL

-- select * from eswiki_p.page where page_namespace = 0 and page_is_redirect = 0 order by page_latest asc limit 10;

-- select * from eswiki_p.page where  page_namespace = 0 and page_is_redirect = 0 order by page_len desc limit 10

/*
select page_title, count(1) conteo
from page
inner join revision on page_id = rev_page
where  page_namespace = 0 and page_is_redirect = 0
group by 1
order by 2 desc
limit 10
*/

select page_title, count(1)
from revision
inner join page on rev_page = page_id
inner join change_tag on ct_rev_id = rev_id
where ct_tag_id in (5, 6) -- 'mw-undo', 'mw-rollback'
	and  page_namespace = 0 and page_is_redirect = 0
group by 1
limit 10
SQL

Checking query status...
