trial - Quarry

Fork of Tewiki: Cricket 2023 project: Orphan Pages by Chaduvari

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

SQL

USE tewiki_p;
SELECT actor_name వాడుకరిపేరు, page1.page_title
FROM
    page p1,revision,actor
  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
    page2.page_id in (select cl_from from categorylinks where cl_to ="క్రికెట్_2023_ప్రాజెక్టులో_భాగంగా_సృష్టించిన_పేజీలు") and
 	page1.page_namespace = 0 and
    page2.page_namespace=1
    and actor_id=rev_actor
  group by actor_name
  ORDER BY 
  page1.page_title

SQL

Checking query status...