| Index: trunk/phase3/includes/specials/SpecialWantedpages.php |
| — | — | @@ -27,19 +27,19 @@ |
| 28 | 28 | $pagelinks = $dbr->tableName( 'pagelinks' ); |
| 29 | 29 | $page = $dbr->tableName( 'page' ); |
| 30 | 30 | $sql = "SELECT 'Wantedpages' AS type, |
| 31 | | - pl_namespace AS namespace, |
| 32 | | - pl_title AS title, |
| 33 | | - COUNT(*) AS value |
| 34 | | - FROM $pagelinks |
| 35 | | - LEFT JOIN $page AS pg1 |
| 36 | | - ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title |
| 37 | | - LEFT JOIN $page AS pg2 |
| 38 | | - ON pl_from = pg2.page_id |
| 39 | | - WHERE pg1.page_namespace IS NULL |
| 40 | | - AND pl_namespace NOT IN ( 2, 3 ) |
| 41 | | - AND pg2.page_namespace != 8 |
| 42 | | - GROUP BY pl_namespace, pl_title |
| 43 | | - HAVING COUNT(*) > $count"; |
| | 31 | + pl_namespace AS namespace, |
| | 32 | + pl_title AS title, |
| | 33 | + COUNT(*) AS value |
| | 34 | + FROM $pagelinks |
| | 35 | + LEFT JOIN $page AS pg1 |
| | 36 | + ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title |
| | 37 | + LEFT JOIN $page AS pg2 |
| | 38 | + ON pl_from = pg2.page_id |
| | 39 | + WHERE pg1.page_namespace IS NULL |
| | 40 | + AND pl_namespace NOT IN ( " . NS_USER . ", ". NS_USER_TALK . ") |
| | 41 | + AND pg2.page_namespace != " . NS_MEDIAWIKI . " |
| | 42 | + GROUP BY pl_namespace, pl_title |
| | 43 | + HAVING COUNT(*) > $count"; |
| 44 | 44 | |
| 45 | 45 | wfRunHooks( 'WantedPages::getSQL', array( &$this, &$sql ) ); |
| 46 | 46 | return $sql; |