SQL
AخA
SELECT
page1.page_title
FROM
page page1,page page2
WHERE
page2.page_title=page1.page_title and
page1.page_title not in (select pl_title from pagelinks where pl_namespace=0 and pl_from_namespace=0) and
page1.page_id in (select cl_from from categorylinks where cl_to ="ఇంగ్లాండు_క్రికెట్_క్రీడాకారులు") and
page2.page_id in (select cl_from from categorylinks where cl_to ="క్రికెట్_2023_ప్రాజెక్టులో_భాగంగా_సృష్టించిన_పేజీలు") and
page1.page_namespace = 0 and
page2.page_namespace=1
ORDER BY
page1.page_title
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.
Query status: complete
Executed in 0.11 seconds as of Fri, 24 Nov 2023 09:23:16 UTC.