From 7fc8348763007d04242bfd68328acb360b29e532 Mon Sep 17 00:00:00 2001 From: Antoine Musso Date: Sat, 29 May 2004 20:55:25 +0000 Subject: [PATCH] Fix sourceforge bug 962795. Ordering is Z-A, will need modifications to be made in the class --- includes/SpecialLonelypages.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/includes/SpecialLonelypages.php b/includes/SpecialLonelypages.php index bd5286414c..86a21a55d0 100644 --- a/includes/SpecialLonelypages.php +++ b/includes/SpecialLonelypages.php @@ -14,9 +14,9 @@ class LonelyPagesPage extends PageQueryPage { function getSQL( $offset, $limit ) { - return "SELECT cur_title FROM cur LEFT JOIN links ON " . - "cur_id=l_to WHERE l_to IS NULL AND cur_namespace=0 AND " . - "cur_is_redirect=0 ORDER BY cur_title LIMIT {$offset}, {$limit}"; + return "SELECT 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"; } } -- 2.20.1