diff options
| author | daniel oeh <daniel.oeh@gmail.com> | 2013-08-31 13:15:04 +0200 |
|---|---|---|
| committer | daniel oeh <daniel.oeh@gmail.com> | 2013-08-31 13:15:04 +0200 |
| commit | 684590665ecc5b3d32bf1041f01ba3a47794a533 (patch) | |
| tree | 79ad20c9aca2c28d7a92b13c5dd9dc484157bf10 | |
| parent | 7b5964bae2b50764d28b10c1fcac72547e9b0738 (diff) | |
| download | AntennaPod-684590665ecc5b3d32bf1041f01ba3a47794a533.zip | |
FeedItemStatistics were wrong if podcast had items with no media file
| -rw-r--r-- | src/de/danoeh/antennapod/storage/PodDBAdapter.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/de/danoeh/antennapod/storage/PodDBAdapter.java b/src/de/danoeh/antennapod/storage/PodDBAdapter.java index bb743e2b1..d36d6184c 100644 --- a/src/de/danoeh/antennapod/storage/PodDBAdapter.java +++ b/src/de/danoeh/antennapod/storage/PodDBAdapter.java @@ -1010,7 +1010,7 @@ public class PodDBAdapter { " MAX(pubDate) AS latest_episode," + " COUNT(CASE WHEN position>0 THEN 1 END) AS in_progress," + " COUNT(CASE WHEN downloaded=1 THEN 1 END) AS episodes_downloaded " + - " FROM FeedItems INNER JOIN FeedMedia ON FeedItems.id=FeedMedia.feeditem GROUP BY FeedItems.feed)" + + " FROM FeedItems LEFT JOIN FeedMedia ON FeedItems.id=FeedMedia.feeditem GROUP BY FeedItems.feed)" + " INNER JOIN Feeds ON Feeds.id = feed ORDER BY Feeds.title;"; public Cursor getFeedStatisticsCursor() { |