Untitled query #86101

SQL

USE commonswiki_p;

-- Get the IDs of the pages that are templates
WITH template_ids AS (
    SELECT page_id
    FROM page
    WHERE page_title IN ('Youtubereview', 'License review')
)

-- Select page titles that are in namespace 6 and do not have the specified templates
SELECT p.page_title
FROM page p
JOIN image i ON p.page_title = i.img_name
WHERE p.page_namespace = 6
  AND p.page_id NOT IN (
    SELECT tl.tl_from
    FROM templatelinks tl
    WHERE tl.tl_target_id IN (SELECT page_id FROM template_ids)
  )
ORDER BY p.page_title;
SQL

Checking query status...
