-- 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

order by 2 desc

limit 10

*/

​

select page_title, count(1)

from page

inner join pagelinks on page_id = pl_from

where page_namespace = 0 and page_is_redirect = 0

group by 1

order by 2 desc

limit 10