Unlinked author page transcluding linked reference template - Quarry

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

SQL

SELECT authorpage.page_title, templatepage.page_title
FROM page authorpage
JOIN templatelinks ON templatelinks.tl_from = authorpage.page_id
JOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_id
JOIN page templatepage ON templatepage.page_title = linktarget.lt_title
WHERE authorpage.page_id = 1183653
AND linktarget.lt_namespace = 10
AND templatepage.page_namespace = 10

AخA
 
SELECT authorpage.page_title, templatepage.page_titleFROM page authorpageJOIN templatelinks ON templatelinks.tl_from = authorpage.page_idJOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_idJOIN page templatepage ON templatepage.page_title = linktarget.lt_titleWHERE authorpage.page_id = 1183653AND linktarget.lt_namespace = 10AND templatepage.page_namespace = 10

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...