5 * @subpackage SpecialPage
11 require_once( "QueryPage.php" );
16 * @subpackage SpecialPage
18 class DeadendPagesPage
extends PageQueryPage
{
21 return "Deadendpages";
25 * LEFT JOIN is expensive
29 function isExpensive( ) {
36 function sortDescending() {
41 * @return string an sqlquery
44 $dbr =& wfGetDB( DB_SLAVE
);
45 extract( $dbr->tableNames( 'cur', 'links' ) );
46 return "SELECT 'Deadendpages' as type, cur_namespace AS namespace, cur_title as title, cur_title AS value " .
47 "FROM $cur LEFT JOIN $links ON cur_id = l_from " .
48 "WHERE l_from IS NULL " .
49 "AND cur_namespace = 0 " .
50 "AND cur_is_redirect = 0";
57 function wfSpecialDeadendpages() {
59 list( $limit, $offset ) = wfCheckLimits();
61 $depp = new DeadendPagesPage();
63 return $depp->doQuery( $offset, $limit );