use ruwiki_p;

select count(*) as количество from page

where page_namespace = 0

and not page_is_redirect;

set @r := 0;

select counter as счётчик, page_id as идентификатор, replace(page_title, '_', ' ') as статья from

(select @r := @r + 1 as counter, page.* from page

where page_namespace = 0

and not page_is_redirect

order by cast(page_id as unsigned) asc) p

where counter <= 1500025

order by counter desc

limit 50