Untitled query #83577

SQL

-- Step 1: Find pages with the "short description" template
WITH short_desc_pages AS (
    SELECT DISTINCT tl_from
    FROM templatelinks
    WHERE tl_target_id = 137
),

-- Step 2: Find pages with templates that generate a short description
template_ids_generating_short_desc AS (
    SELECT DISTINCT tl_from
    FROM templatelinks
    WHERE tl_target_id IN (/* List of template IDs that generate a short description */)
),

-- Step 3: Find pages in the second set but not the first
pages_without_short_desc_template AS (
    SELECT tl_from
    FROM template_ids_generating_short_desc
    WHERE tl_from NOT IN (SELECT tl_from FROM short_desc_pages)
)

-- Select article titles
SELECT page_title
FROM page
WHERE page_id IN (SELECT tl_from FROM pages_without_short_desc_template)
AND page_namespace = 0;
SQL

Checking query status...
