Tewiki:Cricket 2023 - orphan pages in a specific category

Fork of Tewiki:Cricket 2023 - orphan pages in a specific category by Chaduvari

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

SQL

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

SQL

Checking query status...