Untitled query #85460

SQL

-- Find all pages linking to non-existent pages and retrieve titles
SELECT p1.page_title AS linking_page, COUNT(*) AS link_count
FROM pagelinks pl
JOIN page p1 ON pl.pl_from = p1.page_id  -- Join to get the source page title
LEFT JOIN page p2 ON pl.pl_target_id = p2.page_id
WHERE p2.page_id IS NULL  -- The target page does not exist
  AND pl.pl_target_id IS NOT NULL  -- Ensure the target ID is valid
  AND pl.pl_target_namespace = 0  -- Only consider links in the main namespace
  AND pl.pl_namespace = 0  -- Only consider links in the main namespace
  AND p1.page_title LIKE 'Aathur%'  -- Filter source page titles starting with "Aathur"
GROUP BY p1.page_title
HAVING link_count > 0
ORDER BY link_count DESC;
SQL

Checking query status...
