Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Erutuon
.
A selection of random pages to demonstrate a way of printing readable full titles.
Toggle Highlighting
SQL
-- Generated from siteinfo-namespaces in the dump; namespaces.name is the local name, not the canonical name. with namespaces(id, name) as ( values (-2, 'Media'), (-1, 'Special'), (0, ''), (1, 'Talk'), (2, 'User'), (3, 'User talk'), (4, 'Wiktionary'), (5, 'Wiktionary talk'), (6, 'File'), (7, 'File talk'), (8, 'MediaWiki'), (9, 'MediaWiki talk'), (10, 'Template'), (11, 'Template talk'), (12, 'Help'), (13, 'Help talk'), (14, 'Category'), (15, 'Category talk'), (90, 'Thread'), (91, 'Thread talk'), (92, 'Summary'), (93, 'Summary talk'), (100, 'Appendix'), (101, 'Appendix talk'), (102, 'Concordance'), (103, 'Concordance talk'), (104, 'Index'), (105, 'Index talk'), (106, 'Rhymes'), (107, 'Rhymes talk'), (108, 'Transwiki'), (109, 'Transwiki talk'), (110, 'Thesaurus'), (111, 'Thesaurus talk'), (114, 'Citations'), (115, 'Citations talk'), (116, 'Sign gloss'), (117, 'Sign gloss talk'), (118, 'Reconstruction'), (119, 'Reconstruction talk'), (828, 'Module'), (829, 'Module talk'), (2300, 'Gadget'), (2301, 'Gadget talk'), (2302, 'Gadget definition'), (2303, 'Gadget definition talk') ) select page_id, replace(if(namespaces.name = '', page_title, concat(namespaces.name, ':', page_title)), '_', ' ') as title, page_random, page_content_model from page left join namespaces on namespaces.id = page_namespace where page_random between 0.0001 and 0.00012 order by page_namespace, page_title;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...