Replicas browser and optimizer
This query is marked as a draft
This query has been published
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
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in