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
Dalinni
.
Toggle Highlighting
SQL
select page_id, page_title, page_restrictions, page_is_redirect, page_latest, page_lang, cl.cl_to, cl.cl_timestamp, cl.cl_type, cat.cat_pages from page join ( select cl_from as cl_key, cl_to, cl_timestamp, cl_type from categorylinks ) as cl on cl.cl_key = page_id join ( select cat_title as cat_key, cat_pages from categories ) as cat on cat.cat_key = cl.cl_to limit 10
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...