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://ru.wikipedia.org/wiki/ns', CAST('14' AS CHAR(8000) CHARACTER SET utf8), ':', CAST('Выпускники_московского_коммерческого_института' 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 
`ruwiki_p`.`page` Qruwiki_p_pageVIEW0
WHERE 
(Qruwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW0.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_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://ru.wikipedia.org/wiki/', CAST(Qruwiki_p_templatelinksVIEW0.`tl_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`templatelinks` Qruwiki_p_templatelinksVIEW0,
`ruwiki_p`.`page` Qruwiki_p_pageVIEW1
WHERE 
(Qruwiki_p_templatelinksVIEW0.`tl_namespace` = 0) AND
(Qruwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW1.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_p_templatelinksVIEW0.`tl_from` = Qruwiki_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://ru.wikipedia.org/wiki/ns', CAST(Qruwiki_p_templatelinksVIEW0.`tl_namespace` AS CHAR(8000) CHARACTER SET utf8), ':', CAST(Qruwiki_p_templatelinksVIEW0.`tl_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`templatelinks` Qruwiki_p_templatelinksVIEW0,
`ruwiki_p`.`page` Qruwiki_p_pageVIEW1
WHERE 
(Qruwiki_p_templatelinksVIEW0.`tl_namespace` <> 0) AND
(Qruwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW1.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_p_templatelinksVIEW0.`tl_from` = Qruwiki_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 
`ruwiki_p`.`page` Qruwiki_p_pageVIEW0
WHERE 
(Qruwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW0.`page_title` = 'Выпускники_московского_коммерческого_института'))
 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 
`ruwiki_p`.`page` Qruwiki_p_pageVIEW0
WHERE 
(Qruwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW0.`page_title` = 'Выпускники_московского_коммерческого_института'))
 UNION ALL 
 (SELECT 
   1 AS `v0QuestType`, NULL AS `v0Lang`, 'http://schema.org/name' AS `v0`, 
   -3 AS `v1QuestType`, 'ru' AS `v1Lang`, 'Выпускники_московского_коммерческого_института' AS `v1`
 FROM 
`ruwiki_p`.`page` Qruwiki_p_pageVIEW0
WHERE 
(Qruwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW0.`page_title` = 'Выпускники_московского_коммерческого_института'))
 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(Qruwiki_p_pageVIEW0.`page_id` AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`page` Qruwiki_p_pageVIEW0
WHERE 
(Qruwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW0.`page_title` = 'Выпускники_московского_коммерческого_института'))
 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://ru.wikipedia.org/wiki/ns', CAST(Qruwiki_p_pagelinksVIEW0.`pl_namespace` AS CHAR(8000) CHARACTER SET utf8), ':', CAST(Qruwiki_p_pagelinksVIEW0.`pl_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`pagelinks` Qruwiki_p_pagelinksVIEW0,
`ruwiki_p`.`page` Qruwiki_p_pageVIEW1
WHERE 
(Qruwiki_p_pagelinksVIEW0.`pl_namespace` <> 0) AND
(Qruwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW1.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_p_pagelinksVIEW0.`pl_from` = Qruwiki_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://ru.wikipedia.org/wiki/', CAST(Qruwiki_p_pagelinksVIEW0.`pl_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`pagelinks` Qruwiki_p_pagelinksVIEW0,
`ruwiki_p`.`page` Qruwiki_p_pageVIEW1
WHERE 
(Qruwiki_p_pagelinksVIEW0.`pl_namespace` = 0) AND
(Qruwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW1.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_p_pagelinksVIEW0.`pl_from` = Qruwiki_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 
`ruwiki_p`.`page` Qruwiki_p_pageVIEW0
WHERE 
(Qruwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW0.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_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://ru.wikipedia.org/wiki/', CAST(Qruwiki_p_redirectVIEW0.`rd_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`redirect` Qruwiki_p_redirectVIEW0,
`ruwiki_p`.`page` Qruwiki_p_pageVIEW1
WHERE 
(Qruwiki_p_redirectVIEW0.`rd_namespace` = 0) AND
(Qruwiki_p_redirectVIEW0.`rd_interwiki` = '') AND
(Qruwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW1.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_p_redirectVIEW0.`rd_from` = Qruwiki_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://ru.wikipedia.org/wiki/ns', CAST(Qruwiki_p_redirectVIEW0.`rd_namespace` AS CHAR(8000) CHARACTER SET utf8), ':', CAST(Qruwiki_p_redirectVIEW0.`rd_title` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`redirect` Qruwiki_p_redirectVIEW0,
`ruwiki_p`.`page` Qruwiki_p_pageVIEW1
WHERE 
(Qruwiki_p_redirectVIEW0.`rd_namespace` <> 0) AND
(Qruwiki_p_redirectVIEW0.`rd_interwiki` = '') AND
(Qruwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW1.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_p_redirectVIEW0.`rd_from` = Qruwiki_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://ru.wikipedia.org/wiki/ns', CAST(14 AS CHAR(8000) CHARACTER SET utf8), ':', CAST(Qruwiki_p_categorylinksVIEW0.`cl_to` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`categorylinks` Qruwiki_p_categorylinksVIEW0,
`ruwiki_p`.`page` Qruwiki_p_pageVIEW1
WHERE 
(Qruwiki_p_pageVIEW1.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW1.`page_title` = 'Выпускники_московского_коммерческого_института') AND
(Qruwiki_p_categorylinksVIEW0.`cl_from` = Qruwiki_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://ru.wikipedia.org/revision/', CAST(Qruwiki_p_pageVIEW0.`page_latest` AS CHAR(8000) CHARACTER SET utf8)) AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`page` Qruwiki_p_pageVIEW0
WHERE 
(Qruwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW0.`page_title` = 'Выпускники_московского_коммерческого_института'))
 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(Qruwiki_p_pageVIEW0.`page_content_model` AS CHAR(8000) CHARACTER SET utf8) AS `v1`
 FROM 
`ruwiki_p`.`page` Qruwiki_p_pageVIEW0
WHERE 
Qruwiki_p_pageVIEW0.`page_content_model` IS NOT NULL AND
(Qruwiki_p_pageVIEW0.`page_namespace` = '14') AND
(Qruwiki_p_pageVIEW0.`page_title` = 'Выпускники_московского_коммерческого_института'))) 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...
