Issue #1149628 by Ben Coleman: fix blog module query to include all ORDER BY fields...

diff --git a/modules/blog/blog.pages.inc b/modules/blog/blog.pages.inc
index 3c468f9..e4c7074 100644 (file)
--- a/modules/blog/blog.pages.inc
+++ b/modules/blog/blog.pages.inc
@@ -63,7 +63,7 @@ function blog_page_last() {
 
   $output = theme('item_list', $items);
 
-  $result = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC"), variable_get('default_nodes_main', 10));
+  $result = pager_query(db_rewrite_sql("SELECT n.nid, n.sticky, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC"), variable_get('default_nodes_main', 10));
   $has_posts = FALSE;
 
   while ($node = db_fetch_object($result)) {