[livejournal] r21003: LJSUP-11063: sorting order has been chan...

U   trunk/cgi-bin/LJ/DelayedEntry.pm

Modified: trunk/cgi-bin/LJ/DelayedEntry.pm
===================================================================
--- trunk/cgi-bin/LJ/DelayedEntry.pm	2012-01-26 09:23:13 UTC (rev 21002)
+++ trunk/cgi-bin/LJ/DelayedEntry.pm	2012-01-26 11:22:34 UTC (rev 21003)
@@ -793,12 +793,12 @@
         $sql_limit = "LIMIT $skip, $show";
     }
 
-    my $sticky_sql = $sticky_on_top ? 'is_sticky DESC, ' : '';
+    my $sticky_sql = $sticky_on_top ? 'is_sticky ASC, ' : '';
 
     my $journalid = $journal->userid;
     return $dbcr->selectcol_arrayref("SELECT delayedid " .
                                      "FROM delayedlog2 WHERE journalid=$journalid  $sql_poster".
-                                     "ORDER BY $sticky_sql revptime ASC $sql_limit");
+                                     "ORDER BY $sticky_sql revptime DESC $sql_limit");
 }
 
 sub get_first_entry {