diff options
| author | Tom Hennen <tom.hennen@gmail.com> | 2015-11-05 16:59:57 -0500 |
|---|---|---|
| committer | Tom Hennen <tom.hennen@gmail.com> | 2015-11-05 16:59:57 -0500 |
| commit | d2717979be400e927a21edc0d7327bc1d9567571 (patch) | |
| tree | 36b305bbd5318ffe1b2480ece4dac818a4f8523f | |
| parent | 3b003c60abb7ccf461ea5f4eae35e69cdda2ecd2 (diff) | |
| download | AntennaPod-d2717979be400e927a21edc0d7327bc1d9567571.zip | |
sort favorites by publication date
| -rw-r--r-- | core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java | 4 |
1 files changed, 2 insertions, 2 deletions
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; } |