Difference between revisions of "Help:Wanted pages"

Latest revision as of 14:04, 14 July 2006

A page is considered "wanted" if it does not exist, while two or more pages in the project link to it.

The SQL for determining this is from include/SpecialWantedpages.php

 SELECT 'Wantedpages' AS type,
   pl_namespace AS namespace,
   pl_title AS title,
   COUNT(*) AS value
   FROM $pagelinks
   LEFT JOIN $page
   ON pl_namespace=page_namespace AND pl_title=page_title
   WHERE page_namespace IS NULL
   GROUP BY pl_namespace,pl_title
   HAVING COUNT(*) > 1

You can set another threshold by setting 'HAVING COUNT(*) > n'