Help:Wanted pages

From wiki.thepatternofeverything.org

Jump to: navigation, search

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'

Retrieved from "http://wiki.archetypepattern.org/index.php?title=Help:Wanted_pages&oldid=2323"

Help