SQL
AخA
/*
select p1.page_title, p2.page_title from page p1
join pagelinks on pl_from = p1.page_id and pl_from_namespace = 0
join page p2 on p2.page_title = pl_title and p2.page_namespace = pl_namespace
join redirect on rd_from = p2.page_id and rd_title = p1.page_title and rd_namespace = 0
where p1.page_namespace = 0 and p1.page_id in (
select cl_from from categorylinks
where cl_to in ("All_disambiguation_pages", "All_set_index_articles") and cl_type = "page"
)
and p1.page_id not in (
select tl_from from templatelinks
where tl_from_namespace = 2 and tl_target_id in (
select lt_id from linktarget where lt_namespace = 10 and lt_title = "Broad-concept_article"
)
)
*/
select lt_id from linktarget where lt_namespace = 10 and lt_title = "Dabconcept"
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.