10 class DeadendPagesPage
extends PageQueryPage
{
13 return "Deadendpages";
16 function getPageHeader() {
17 return wfMsgExt( 'deadendpagestext', array( 'parse' ) );
21 * LEFT JOIN is expensive
25 function isExpensive( ) {
29 function isSyndicated() { return false; }
34 function sortDescending() {
39 * @return string an sqlquery
42 $dbr = wfGetDB( DB_SLAVE
);
43 list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' );
44 return "SELECT 'Deadendpages' as type, page_namespace AS namespace, page_title as title, page_title AS value " .
45 "FROM $page LEFT JOIN $pagelinks ON page_id = pl_from " .
46 "WHERE pl_from IS NULL " .
47 "AND page_namespace = 0 " .
48 "AND page_is_redirect = 0";
55 function wfSpecialDeadendpages() {
57 list( $limit, $offset ) = wfCheckLimits();
59 $depp = new DeadendPagesPage();
61 return $depp->doQuery( $offset, $limit );