Untitled query #86105

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 ('PD-old', 'Domaine public', 'GFDL', 'DP-EU', 'CC-BY-SA')
)

-- Select page titles that are in namespace 6 and not linked to 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...
