Orphaned articles with more than two incoming links

Fork of Orphaned articles with more than two incoming links by GoingBatty

This query is marked as a draft This query has been published by Josve05a.

Articles tagged with {{orphan}} that have more than two incoming links.  These are candidates to have the {{orphan}} template removed.

SQL

require_once( "QueryPage.php" );

class LonelyPagesPage extends PageQueryPage {
  
  function getName() {
    return "Lonelypages";
  }
  
  function sortDescending() {
    return false;
  }

  function isExpensive() {
    return true;
  }
  
  function getSQL() {
    return "SELECT 'Lonelypages' as type, cur_namespace AS namespace, cur_title AS title, cur_title AS value " .
      "FROM cur LEFT JOIN links ON cur_id=l_to ".
      "WHERE l_to IS NULL AND cur_namespace=0 AND cur_is_redirect=0";
  }
}

function wfSpecialLonelypages() {
  list( $limit, $offset ) = wfCheckLimits();
  
  $lpp = new LonelyPagesPage();
  
  return $lpp->doQuery( $offset, $limit );
}

SQL

Checking query status...