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 * from revision
inner join change_tag on ct_rid = rev_id
where ctag_id in (5, 6) -- 'mw-undo', 'mw-rollback'
limit 10
SQL

Checking query status...
