Difference between revisions of "Help:Wanted pages"
From wiki.thepatternofeverything.org
Line 1: | Line 1: | ||
− | A page is considered "wanted" if it does not exist, while two or more pages in the project link to it. | + | 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 | The SQL for determining this is from include/SpecialWantedpages.php |
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'