Ruwiki article counter

SQL

use ruwiki_p;
select * from
(select @r := @r+1 as counter, cast(id0 as unsigned) as id1 from (
select page_title as article, 
  cast(id as unsigned) as id0
  from
(select page_title, cast(page_id as unsigned) as id from page
where page_namespace = 0
and not page_is_redirect
order by cast(page_id as unsigned) asc)f
)z join (select @r:=0)y )h
having counter > 0#1477600
limit 50;
select count(*) from page
where page_namespace = 0
and not page_is_redirect;
select * from page
where page_namespace = 0
and not page_is_redirect
order by cast(page_id as unsigned) asc
limit 50
SQL

Checking query status...
