SQL
AخA
SELECT *
from page
left join templatelinks on page_id = tl_target_id #and tl_from_namespace = 0
#left join linktarget on lt_id = tl_target_id on lt_id = page_id #and lt_namespace = page_namespace
where
#page_namespace = 106 and
page_content_model = "proofread-index"
#and tl_from is null
#page_content_model = "proofread-page"
#FROM templatelinks
#WHERE tl_target_id = 1706714;
#INNER JOIN linktarget ON tl_target_id = lt_id
#inner join page on page_id = tl_from
#WHERE lt_namespace = "106"
and page_id = 182196
limit 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.