diff options
| author | David-Development <david-dev@live.de> | 2014-06-04 19:42:16 +0400 |
|---|---|---|
| committer | David-Development <david-dev@live.de> | 2014-06-04 19:42:16 +0400 |
| commit | bdf239ae5beeda0d55ca4a0b5fad5ef4ffe04f2f (patch) | |
| tree | 6ffdfb931d692694835a7f253f41c6c32579b76f /News-Android-App/src/main | |
| parent | 75184dad7ad7ee3308e0950206021039a4fba733 (diff) | |
fix bug in SQL statement
Diffstat (limited to 'News-Android-App/src/main')
| -rw-r--r-- | News-Android-App/src/main/java/de/luhmer/owncloudnewsreader/database/DatabaseConnection.java | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/News-Android-App/src/main/java/de/luhmer/owncloudnewsreader/database/DatabaseConnection.java b/News-Android-App/src/main/java/de/luhmer/owncloudnewsreader/database/DatabaseConnection.java index b4937ae3..0bbcbde3 100644 --- a/News-Android-App/src/main/java/de/luhmer/owncloudnewsreader/database/DatabaseConnection.java +++ b/News-Android-App/src/main/java/de/luhmer/owncloudnewsreader/database/DatabaseConnection.java @@ -48,8 +48,8 @@ public class DatabaseConnection { public SparseArray<String> getUnreadItemCountForFolder(Context mContext) { String buildSQL = "SELECT " + FOLDER_LABEL_ID + ", COUNT(" + RSS_ITEM_RSSITEM_ID + ")" + " FROM " + RSS_ITEM_TABLE + " rss " + - " JOIN " + SUBSCRIPTION_TABLE + " st ON rss." + RSS_ITEM_SUBSCRIPTION_ID + " = st." + SUBSCRIPTION_ID + - " JOIN " + FOLDER_TABLE + " f ON st." + SUBSCRIPTION_FOLDER_ID + " = f." + FOLDER_LABEL_ID + + " JOIN " + SUBSCRIPTION_TABLE + " st ON rss." + RSS_ITEM_SUBSCRIPTION_ID + " = st.rowid" + + " JOIN " + FOLDER_TABLE + " f ON st." + SUBSCRIPTION_FOLDER_ID + " = f.rowid" + " WHERE " + RSS_ITEM_READ_TEMP + " != 1 " + " GROUP BY f." + FOLDER_LABEL_ID; |