diff options
author | Tom Hennen <TomHennen@users.noreply.github.com> | 2015-11-06 15:43:35 -0500 |
---|---|---|
committer | Tom Hennen <TomHennen@users.noreply.github.com> | 2015-11-06 15:43:35 -0500 |
commit | 45be2a2f659fc87def2224b177e6646cdefccb4b (patch) | |
tree | 36b305bbd5318ffe1b2480ece4dac818a4f8523f /core/src/main | |
parent | 3b003c60abb7ccf461ea5f4eae35e69cdda2ecd2 (diff) | |
parent | d2717979be400e927a21edc0d7327bc1d9567571 (diff) | |
download | AntennaPod-45be2a2f659fc87def2224b177e6646cdefccb4b.zip |
Merge pull request #1342 from TomHennen/sort_fav
sort favorites by publication date
Diffstat (limited to 'core/src/main')
-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; } |