Pages that transclude Episode list without Episode Table template/module - Quarry

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

SQL

SELECT page_title FROM templatelinks join linktarget on tl_target_id = lt_id
WHERE lt_title="Episode list"
AND NOT exists (
    SELECT *
    FROM templatelinks JOIN linktarget ON lt_id = tl_target_id
    WHERE tl_from=page_id 
    AND lt_title="Episode table"
	limit 1 
)

AخA
 
SELECT page_title FROM templatelinks join linktarget on tl_target_id = lt_idWHERE lt_title="Episode list"AND NOT exists (    SELECT *    FROM templatelinks JOIN linktarget ON lt_id = tl_target_id    WHERE tl_from=page_id     AND lt_title="Episode table"    limit 1 )

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...