3 require_once( "QueryPage.php" );
5 class DeadendPagesPage
extends PageQueryPage
{
11 # LEFT JOIN is expensive
13 function isExpensive( ) {
17 function sortDescending() {
22 $dbr =& wfGetDB( DB_SLAVE
);
23 extract( $dbr->tableNames( 'cur', 'links' ) );
24 return "SELECT 'Deadendpages' as type, cur_namespace AS namespace, cur_title as title, cur_title AS value " .
25 "FROM $cur LEFT JOIN $links ON cur_id = l_from " .
26 "WHERE l_from IS NULL " .
27 "AND cur_namespace = 0 " .
28 "AND cur_is_redirect = 0";
32 function wfSpecialDeadendpages() {
34 list( $limit, $offset ) = wfCheckLimits();
36 $depp = new DeadendPagesPage();
38 return $depp->doQuery( $offset, $limit );