Untitled query #85463

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

SQL

SELECT p1.page_title AS linking_page, COUNT(*) AS link_count
FROM pagelinks pl
JOIN page p1 ON pl.pl_from = p1.page_id  -- Source page
LEFT JOIN page p2 ON pl.pl_target_id = p2.page_id  -- Target page
WHERE p2.page_id IS NULL  -- Non-existent target page
  AND pl.pl_target_id IS NOT NULL  -- Ensure target ID is valid
GROUP BY p1.page_title
HAVING link_count > 0
ORDER BY link_count DESC
LIMIT 10;  -- Limit the number of rows returned for preview

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.

SQL

Checking query status...