Untitled query #18741

SQL

SELECT 
   1 AS `fooQuestType`, NULL AS `fooLang`, 'http://tools.wmflabs.org/mw2sparql/ontology#internalLinkTo' AS `foo`, 
   1 AS `objectQuestType`, NULL AS `objectLang`, CONCAT('http://en.wikipedia.org/wiki/', REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CAST(QVIEW4.`ns_name` AS CHAR(8000) CHARACTER SET utf8), ' ', '%20'), '!', '%21'), '''', '%22'), '#', '%23'), '$', '%24'), '&', '%26'), '(', '%28'), ')', '%29'), '*', '%2A'), '+', '%2B'), ',', '%2C'), '/', '%2F'), ':', '%3A'), ';', '%3B'), '=', '%3D'), '?', '%3F'), '@', '%40'), '[', '%5B'), ']', '%5D'), ':', REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CAST(QVIEW2.`pl_title` AS CHAR(8000) CHARACTER SET utf8), ' ', '%20'), '!', '%21'), '''', '%22'), '#', '%23'), '$', '%24'), '&', '%26'), '(', '%28'), ')', '%29'), '*', '%2A'), '+', '%2B'), ',', '%2C'), '/', '%2F'), ':', '%3A'), ';', '%3B'), '=', '%3D'), '?', '%3F'), '@', '%40'), '[', '%5B'), ']', '%5D')) AS `object`
 FROM 
`s53381__extra`.`enwiki_ns_id2name` QVIEW1,
`enwiki_p`.`pagelinks` QVIEW2,
`enwiki_p`.`page` QVIEW3,
`s53381__extra`.`enwiki_ns_id2name` QVIEW4
WHERE 
(QVIEW1.`ns_name` = 'Help') AND
(QVIEW2.`pl_from` = QVIEW3.`page_id`) AND
(QVIEW1.`ns_id` = QVIEW3.`page_namespace`) AND
(QVIEW3.`page_title` = 'Contents') AND
(QVIEW2.`pl_namespace` = QVIEW4.`ns_id`) AND
QVIEW2.`pl_title` IS NOT NULL AND
QVIEW4.`ns_name` IS NOT NULL
UNION ALL
SELECT 
   1 AS `fooQuestType`, NULL AS `fooLang`, 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS `foo`, 
   1 AS `objectQuestType`, NULL AS `objectLang`, 'http://tools.wmflabs.org/mw2sparql/ontology#Page' AS `object`
 FROM 
`s53381__extra`.`enwiki_ns_id2name` QVIEW1,
`enwiki_p`.`pagelinks` QVIEW2,
`enwiki_p`.`page` QVIEW3,
`s53381__extra`.`enwiki_ns_id2name` QVIEW4
WHERE 
(QVIEW2.`pl_title` = 'Contents') AND
(QVIEW2.`pl_from` = QVIEW3.`page_id`) AND
(QVIEW1.`ns_id` = QVIEW3.`page_namespace`) AND
(QVIEW2.`pl_namespace` = QVIEW4.`ns_id`) AND
(QVIEW4.`ns_name` = 'Help')
UNION ALL
SELECT 
   1 AS `fooQuestType`, NULL AS `fooLang`, 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS `foo`, 
   1 AS `objectQuestType`, NULL AS `objectLang`, 'http://tools.wmflabs.org/mw2sparql/ontology#Page' AS `object`
 FROM 
`s53381__extra`.`enwiki_ns_id2name` QVIEW1,
`enwiki_p`.`pagelinks` QVIEW2,
`enwiki_p`.`page` QVIEW3,
`s53381__extra`.`enwiki_ns_id2name` QVIEW4
WHERE 
(QVIEW1.`ns_name` = 'Help') AND
(QVIEW2.`pl_from` = QVIEW3.`page_id`) AND
(QVIEW1.`ns_id` = QVIEW3.`page_namespace`) AND
(QVIEW3.`page_title` = 'Contents') AND
(QVIEW2.`pl_namespace` = QVIEW4.`ns_id`)
SQL

Checking query status...
