From 44d1e723dfaeb1ad5980f8b0b1744cd2b58ea9ce Mon Sep 17 00:00:00 2001
From: Zach Copley <zach@controlyourself.ca>
Date: Fri, 23 Jan 2009 12:12:51 +0000
Subject: trac750 fixed dumb sql query that was pulling ancient notices

---
 lib/facebookutil.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'lib/facebookutil.php')

diff --git a/lib/facebookutil.php b/lib/facebookutil.php
index b4c73da87..8454590d6 100644
--- a/lib/facebookutil.php
+++ b/lib/facebookutil.php
@@ -32,7 +32,8 @@ function getFacebookNotices($since)
         'FROM notice ' .
         'JOIN foreign_link ' .
         'WHERE notice.profile_id = foreign_link.user_id ' .
-        'AND foreign_link.service = 2';
+        'AND foreign_link.service = 2 ' . 
+        'ORDER BY notice.created DESC';
 
     // XXX: What should the limit be?
     return Notice::getStreamDirect($qry, 0, 100, 0, 0, null, $since);
-- 
cgit v1.2.3-54-g00ecf