5 * @subpackage SpecialPage
11 require_once( "QueryPage.php" );
16 * @subpackage SpecialPage
18 class LonelyPagesPage
extends PageQueryPage
{
24 function sortDescending() {
28 function isExpensive() {
31 function isSyndicated() { return false; }
34 $dbr =& wfGetDB( DB_SLAVE
);
35 extract( $dbr->tableNames( 'page', 'links' ) );
37 return "SELECT 'Lonelypages' as type, page_namespace AS namespace, page_title AS title, page_title AS value " .
38 "FROM $page LEFT JOIN $links ON page_id=l_to ".
39 'WHERE l_to IS NULL AND page_namespace='.NS_MAIN
.' AND page_is_redirect=0';
46 function wfSpecialLonelypages() {
47 list( $limit, $offset ) = wfCheckLimits();
49 $lpp = new LonelyPagesPage();
51 return $lpp->doQuery( $offset, $limit );