| Index: branches/querypage-work2/phase3/includes/specials/SpecialBrokenRedirects.php |
| — | — | @@ -27,7 +27,7 @@ |
| 28 | 28 | |
| 29 | 29 | function getQueryInfo() { |
| 30 | 30 | return array( |
| 31 | | - 'tables' => array( 'redirect', 'page AS p1', 'page AS p2' ), |
| | 31 | + 'tables' => array( 'redirect', 'page p1', 'page p2' ), |
| 32 | 32 | 'fields' => array( 'p1.page_namespace AS namespace', |
| 33 | 33 | 'p1.page_title AS title', |
| 34 | 34 | 'rd_namespace', |
| — | — | @@ -36,10 +36,10 @@ |
| 37 | 37 | 'conds' => array( 'rd_namespace >= 0', |
| 38 | 38 | 'p2.page_namespace IS NULL' |
| 39 | 39 | ), |
| 40 | | - 'join_conds' => array( 'page AS p1' => array( 'LEFT JOIN', array( |
| | 40 | + 'join_conds' => array( 'page p1' => array( 'LEFT JOIN', array( |
| 41 | 41 | 'rd_from=p1.page_id', |
| 42 | 42 | ) ), |
| 43 | | - 'page AS p2' => array( 'LEFT JOIN', array( |
| | 43 | + 'page p2' => array( 'LEFT JOIN', array( |
| 44 | 44 | 'rd_namespace=p2.page_namespace', |
| 45 | 45 | 'rd_title=p2.page_title' |
| 46 | 46 | ) ) |
| Index: branches/querypage-work2/phase3/includes/specials/SpecialDoubleRedirects.php |
| — | — | @@ -27,9 +27,9 @@ |
| 28 | 28 | function reallyGetQueryInfo( $namespace = null, $title = null ) { |
| 29 | 29 | $limitToTitle = !( $namespace === null && $title === null ); |
| 30 | 30 | $retval = array ( |
| 31 | | - 'tables' => array ( 'redirect AS ra', 'redirect AS rb', |
| 32 | | - 'page AS pa', 'page AS pb', |
| 33 | | - 'page AS pc' ), |
| | 31 | + 'tables' => array ( 'redirect ra', 'redirect rb', |
| | 32 | + 'page pa', 'page pb', |
| | 33 | + 'page pc' ), |
| 34 | 34 | 'fields' => array ( 'pa.page_namespace AS namespace', |
| 35 | 35 | 'pa.page_title AS title', |
| 36 | 36 | 'pb.page_namespace AS nsb', |
| Index: branches/querypage-work2/phase3/includes/specials/SpecialListredirects.php |
| — | — | @@ -25,7 +25,7 @@ |
| 26 | 26 | |
| 27 | 27 | function getQueryInfo() { |
| 28 | 28 | return array( |
| 29 | | - 'tables' => array( 'page AS p1', 'redirect', 'page AS p2' ), |
| | 29 | + 'tables' => array( 'page p1', 'redirect', 'page p2' ), |
| 30 | 30 | 'fields' => array( 'p1.page_namespace AS namespace', |
| 31 | 31 | 'p1.page_title AS title', |
| 32 | 32 | 'rd_namespace', |
| — | — | @@ -34,7 +34,7 @@ |
| 35 | 35 | 'conds' => array( 'p1.page_is_redirect' => 1 ), |
| 36 | 36 | 'join_conds' => array( 'redirect' => array( |
| 37 | 37 | 'LEFT JOIN', 'rd_from=p1.page_id' ), |
| 38 | | - 'page AS p2' => array( 'LEFT JOIN', array( |
| | 38 | + 'page p2' => array( 'LEFT JOIN', array( |
| 39 | 39 | 'p2.page_namespace=rd_namespace', |
| 40 | 40 | 'p2.page_title=rd_title' ) ) ) |
| 41 | 41 | ); |