Untitled query #26724

This query is marked as a draft This query has been published by Ghuron.
SQL

SELECT 
   1 AS `articleQuestType`, NULL AS `articleLang`, CAST(CONCAT('https://fr.wikipedia.org/wiki/ns', CAST('14' AS CHAR(8000) CHARACTER SET utf8), ':', CAST('Mer_d''Europe' AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `article`, 
   QansSQ1View.`v0QuestType` AS `predicateQuestType`, QansSQ1View.`v0Lang` AS `predicateLang`, CAST(QansSQ1View.`v0` AS CHAR(8000) CHARACTER SET utf8) AS `predicate`, 
   QansSQ1View.`v1QuestType` AS `objectQuestType`, QansSQ1View.`v1Lang` AS `objectLang`, CAST(QansSQ1View.`v1` AS CHAR(8000) CHARACTER SET utf8) AS `object`
 FROM 
((SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#NewPage' AS `v1`
 FROM 
`frwiki_p`.`page` Qfrwiki_p_pageVIEW0
WHERE 
(Qfrwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW0.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_pageVIEW0.`page_is_new` = 1))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#includesPage' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, CAST(CONCAT('https://fr.wikipedia.org/wiki/', CAST(Qfrwiki_p_templatelinksVIEW0.`tl_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`templatelinks` Qfrwiki_p_templatelinksVIEW0,
`frwiki_p`.`page` Qfrwiki_p_pageVIEW1
WHERE 
(Qfrwiki_p_templatelinksVIEW0.`tl_namespace` = 0) AND
(Qfrwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW1.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_templatelinksVIEW0.`tl_from` = Qfrwiki_p_pageVIEW1.`page_id`))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#includesPage' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, CAST(CONCAT('https://fr.wikipedia.org/wiki/ns', CAST(Qfrwiki_p_templatelinksVIEW0.`tl_namespace` AS CHAR(8000) CHARACTER SET utf8), ':', CAST(Qfrwiki_p_templatelinksVIEW0.`tl_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`templatelinks` Qfrwiki_p_templatelinksVIEW0,
`frwiki_p`.`page` Qfrwiki_p_pageVIEW1
WHERE 
(Qfrwiki_p_templatelinksVIEW0.`tl_namespace` <> 0) AND
(Qfrwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW1.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_templatelinksVIEW0.`tl_from` = Qfrwiki_p_pageVIEW1.`page_id`))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#Page' AS `v1`
 FROM 
`frwiki_p`.`page` Qfrwiki_p_pageVIEW0
WHERE 
(Qfrwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW0.`page_title` = 'Mer_d''Europe'))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#pageNamespaceId' AS `v0`, 
   4 AS `v1QuestType`, NULL AS `v1Lang`, '14' AS `v1`
 FROM 
`frwiki_p`.`page` Qfrwiki_p_pageVIEW0
WHERE 
(Qfrwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW0.`page_title` = 'Mer_d''Europe'))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://schema.org/name' AS `v0`, 
   -3 AS `v1QuestType`, 'fr' AS `v1Lang`, 'Mer_d''Europe' AS `v1`
 FROM 
`frwiki_p`.`page` Qfrwiki_p_pageVIEW0
WHERE 
(Qfrwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW0.`page_title` = 'Mer_d''Europe'))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#pageId' AS `v0`, 
   4 AS `v1QuestType`, NULL AS `v1Lang`, CAST(Qfrwiki_p_pageVIEW0.`page_id` AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`page` Qfrwiki_p_pageVIEW0
WHERE 
(Qfrwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW0.`page_title` = 'Mer_d''Europe'))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#internalLinkTo' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, CAST(CONCAT('https://fr.wikipedia.org/wiki/', CAST(Qfrwiki_p_pagelinksVIEW0.`pl_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`pagelinks` Qfrwiki_p_pagelinksVIEW0,
`frwiki_p`.`page` Qfrwiki_p_pageVIEW1
WHERE 
(Qfrwiki_p_pagelinksVIEW0.`pl_namespace` = 0) AND
(Qfrwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW1.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_pagelinksVIEW0.`pl_from` = Qfrwiki_p_pageVIEW1.`page_id`))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#internalLinkTo' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, CAST(CONCAT('https://fr.wikipedia.org/wiki/ns', CAST(Qfrwiki_p_pagelinksVIEW0.`pl_namespace` AS CHAR(8000) CHARACTER SET utf8), ':', CAST(Qfrwiki_p_pagelinksVIEW0.`pl_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`pagelinks` Qfrwiki_p_pagelinksVIEW0,
`frwiki_p`.`page` Qfrwiki_p_pageVIEW1
WHERE 
(Qfrwiki_p_pagelinksVIEW0.`pl_namespace` <> 0) AND
(Qfrwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW1.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_pagelinksVIEW0.`pl_from` = Qfrwiki_p_pageVIEW1.`page_id`))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#RedirectPage' AS `v1`
 FROM 
`frwiki_p`.`page` Qfrwiki_p_pageVIEW0
WHERE 
(Qfrwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW0.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_pageVIEW0.`page_is_redirect` = 1))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#redirectsTo' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, CAST(CONCAT('https://fr.wikipedia.org/wiki/ns', CAST(Qfrwiki_p_redirectVIEW0.`rd_namespace` AS CHAR(8000) CHARACTER SET utf8), ':', CAST(Qfrwiki_p_redirectVIEW0.`rd_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`redirect` Qfrwiki_p_redirectVIEW0,
`frwiki_p`.`page` Qfrwiki_p_pageVIEW1
WHERE 
(Qfrwiki_p_redirectVIEW0.`rd_namespace` <> 0) AND
(Qfrwiki_p_redirectVIEW0.`rd_interwiki` = '') AND
(Qfrwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW1.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_redirectVIEW0.`rd_from` = Qfrwiki_p_pageVIEW1.`page_id`))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#redirectsTo' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, CAST(CONCAT('https://fr.wikipedia.org/wiki/', CAST(Qfrwiki_p_redirectVIEW0.`rd_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`redirect` Qfrwiki_p_redirectVIEW0,
`frwiki_p`.`page` Qfrwiki_p_pageVIEW1
WHERE 
(Qfrwiki_p_redirectVIEW0.`rd_namespace` = 0) AND
(Qfrwiki_p_redirectVIEW0.`rd_interwiki` = '') AND
(Qfrwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW1.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_redirectVIEW0.`rd_from` = Qfrwiki_p_pageVIEW1.`page_id`))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#inCategory' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, CAST(CONCAT('https://fr.wikipedia.org/wiki/ns', CAST(14 AS CHAR(8000) CHARACTER SET utf8), ':', CAST(Qfrwiki_p_categorylinksVIEW0.`cl_to` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`categorylinks` Qfrwiki_p_categorylinksVIEW0,
`frwiki_p`.`page` Qfrwiki_p_pageVIEW1
WHERE 
(Qfrwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW1.`page_title` = 'Mer_d''Europe') AND
(Qfrwiki_p_categorylinksVIEW0.`cl_from` = Qfrwiki_p_pageVIEW1.`page_id`))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#pageLatestRevision' AS `v0`, 
   1 AS `v1QuestType`, NULL AS `v1Lang`, CAST(CONCAT('https://fr.wikipedia.org/revision/', CAST(Qfrwiki_p_pageVIEW0.`page_latest` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`page` Qfrwiki_p_pageVIEW0
WHERE 
(Qfrwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW0.`page_title` = 'Mer_d''Europe'))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://tools.wmflabs.org/mw2sparql/ontology#pageContentModelId' AS `v0`, 
   7 AS `v1QuestType`, NULL AS `v1Lang`, CAST(Qfrwiki_p_pageVIEW0.`page_content_model` AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`frwiki_p`.`page` Qfrwiki_p_pageVIEW0
WHERE 
Qfrwiki_p_pageVIEW0.`page_content_model` IS NOT NULL AND
(Qfrwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qfrwiki_p_pageVIEW0.`page_title` = 'Mer_d''Europe'))) QansSQ1View
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.
SQL

Checking query status...
