From d2717979be400e927a21edc0d7327bc1d9567571 Mon Sep 17 00:00:00 2001 From: Tom Hennen Date: Thu, 5 Nov 2015 16:59:57 -0500 Subject: sort favorites by publication date --- .../src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'core/src/main/java') diff --git a/core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java b/core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java index 7d1afc039..6ccb1d226 100644 --- a/core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java +++ b/core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java @@ -1052,8 +1052,8 @@ public class PodDBAdapter { TABLE_NAME_FEED_ITEMS, TABLE_NAME_FAVORITES, TABLE_NAME_FEED_ITEMS + "." + KEY_ID, TABLE_NAME_FAVORITES + "." + KEY_FEEDITEM, - TABLE_NAME_FAVORITES + "." + KEY_ID }; - String query = String.format("SELECT %s FROM %s INNER JOIN %s ON %s=%s ORDER BY %s", args); + TABLE_NAME_FEED_ITEMS + "." + KEY_PUBDATE }; + String query = String.format("SELECT %s FROM %s INNER JOIN %s ON %s=%s ORDER BY %s DESC", args); Cursor c = db.rawQuery(query, null); return c; } -- cgit v1.2.3