Filters: episodes from unsubscribed podcasts added to the Unplayed filter

[pocketcasts]

Filters: episodes from unsubscribed podcasts added to the Unplayed filter

[pocketcasts]

Aditional info from Russell:

I'm not really sure what would cause this, but the behaviour leads me to believe that:

• A podcast was deleted off the local device, however for some reason the episodes for it remained
• These would only be picked up in a filter, because that's a query on the episodes table and nothing else
• Brady is unable to tap any episodes, because when he does the app tries to load the podcast for them, and there isn't one

The next step I think would be to manually simulate this by running a query to just delete a podcast from the database without clearing the episodes. Once we know the behaviour is identical we could try to figure out what caused it

The above seems to be confirmed in the code. Podcasts are removed from a filter query by doing a NOT IN operation, meaning if they aren't on the device but the episodes the episodes would still appear:

let unsubscribedUuids = DataManager.sharedManager.allUnsubscribedPodcastUuids()
        if unsubscribedUuids.count > 0 {
            if haveStartedWhere { queryString += "AND " }
            
            queryString += " podcastUuid NOT IN ("