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

SQL

AخA
 
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
JOIN categorylinks templatecat ON templatecat.cl_from = templatepage.page_id
WHERE authorpage.page_id = 1183653
AND linktarget.lt_namespace = 10
AND templatepage.page_namespace = 10
AND templatecat.cl_to = "Reference_templates"
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
All SQL code is licensed under CC0 License.

Checking query status...