diff options
-rw-r--r-- | WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java index d9221ad92..822b28146 100644 --- a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java +++ b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java @@ -99,9 +99,14 @@ public class PeopleTable { int fetchLimit = PeopleUtils.FETCH_USERS_LIMIT; if (size > fetchLimit) { int deleteCount = size - fetchLimit; - String[] args = new String[]{Integer.toString(deleteCount), Integer.toString(localTableBlogId)}; - getWritableDb().delete(PEOPLE_TABLE, "person_id " + - "IN (SELECT person_id FROM people ORDER BY display_name DESC LIMIT ?) AND local_blog_id=?", args); + String[] args = new String[] { + Integer.toString(localTableBlogId), + Integer.toString(localTableBlogId), + Integer.toString(deleteCount) + }; + getWritableDb().delete(PEOPLE_TABLE, "local_blog_id=? AND person_id " + + "IN (SELECT person_id FROM " + PEOPLE_TABLE + " WHERE local_blog_id=? " + + "ORDER BY display_name DESC LIMIT ?)", args); } } |