Difference between revisions of "Help:Wanted page"
Jump to navigation
Jump to search
m (1 revision: Import helps) |
(No difference)
|
Latest revision as of 17:24, 10 January 2011
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'