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
Adù229
.
Toggle Highlighting
SQL
SELECT `p`.`page_id` AS "page_id", CAST(`p`.`page_title` AS CHAR(10000) CHARACTER SET utf8) AS "page_title", `r`.`rev_text_id` AS "revision_id", `t`.`old_id` AS "text_id" FROM page p INNER JOIN `revision` r ON `p`.`page_id` = `r`.`rev_page` -- Confirmed to be reference to page.page_id INNER JOIN `text` t ON `r`.`rev_text_id` = `t`.`old_id` -- Confirmed to be reference to revision table WHERE `p`.`page_title` LIKE '%Tests/parent-a%'; -- Match with title of a parent page
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...