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
BrandonXLF
.
Toggle Highlighting
SQL
USE wikidata_p; SELECT page_id, page_namespace, page_title, rd_from, rd_fragment, page_is_redirect FROM ( SELECT pl_from, rd_from, rd_fragment FROM `pagelinks` LEFT JOIN `redirect` ON ((rd_from = pl_from) AND rd_title = 'P248' AND (rd_interwiki = '' OR rd_interwiki IS NULL) AND rd_namespace = 120 ) JOIN `page` ON ((pl_from = page_id)) WHERE pl_namespace = 120 AND pl_title = 'P248' ORDER BY pl_from LIMIT 102 ) `temp_backlink_range` JOIN `page` ON ((pl_from = page_id)) ORDER BY page_id LIMIT 51
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...