# Audio stream in database **URL:** \ **Category:** Plex Media Server\ **Tags:** server-linux\ **Created:** [June 1, 2020, 9:26pm UTC](https://forums.plex.tv/t/audio-stream-in-database/598514 "2020-06-01T21:26:06Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![krugster](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/krugster/32/90414_2.png) [@krugster](https://forums.plex.tv/u/krugster)\ **Post date:** [June 1, 2020, 9:26pm UTC](https://forums.plex.tv/t/audio-stream-in-database/598514/1 "2020-06-01T21:26:07Z")
hopefully a simple question but wasn’t obvious where to place it topic-wise… I recently added a bunch of movies and realized that not all have an English audio stream (dubbed into Russian for example). I was poking around the PMS database but I couldn’t find where the audio language was stored for a particular media file. I’m hoping to run a query and get back a list of movies that don’t have an English audio stream. Thanks in advance! ---
**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\ **Post date:** [June 1, 2020, 9:51pm UTC](https://forums.plex.tv/t/audio-stream-in-database/598514/2 "2020-06-01T21:51:50Z")
No need for a query. Just create a custom filter. ![image](https://global.discourse-cdn.com/plex/original/3X/2/9/297604273a750622eeb868200944102f0c87e185.jpeg) Keep in mind that if the language is not set, it will be seen as unknown. Or you can do the opposite and look for ones only in a foreign lanaguage. You’ll be shown a list of language so you don’t need to know what they are, just pick them from the list. ![image](https://global.discourse-cdn.com/plex/original/3X/3/8/38fbb9e11f9c83eb2d42953453fabd699ce80f4c.jpeg) ---
**Author:** ![krugster](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/krugster/32/90414_2.png) [@krugster](https://forums.plex.tv/u/krugster)\ **Post date:** [June 2, 2020, 9:51am UTC](https://forums.plex.tv/t/audio-stream-in-database/598514/3 "2020-06-02T09:51:08Z")
Oh great, thanks for that…I didn’t even realize that the smart playlists were so powerful! While I’m here, a few more questions/improvements: - I don’t see a way to filter on “Unknown”. There is a “Not Applicable” item in the language list, but it seems no “Unknown” option? - Unrelated to filtering, is there any (easy?) way to remove audio streams from a file? I have a couple that have both English and another one and it would make filtering a bit easier going forward if I could remove the non-English one where appropriate. - A minor bug, when selecting a language from the list, that language isn’t removed from the selection list so it’s hard to see which ones are already selected or not. Thanks again for your help! ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [June 2, 2020, 10:47am UTC](https://forums.plex.tv/t/audio-stream-in-database/598514/4 "2020-06-02T10:47:46Z")
> [@krugster](#): > > Unrelated to filtering, is there any (easy?) way to remove audio streams from a file? I have a couple that have both English and another one and it would make filtering a bit easier going forward if I could remove the non-English one where appropriate. Get [MKVtoolnixGUI](https://mkvtoolnix.download/ "MKVtoolnixGUI") drag the media file into it, disable all the tracks you don’t want ‘Start Muxing’ The result is a MKV file which has the streams from your original file unchanged (i.e. no quality degradation), minus the tracks you disabled. ---
**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\ **Post date:** [June 2, 2020, 6:12pm UTC](https://forums.plex.tv/t/audio-stream-in-database/598514/5 "2020-06-02T18:12:00Z")
1 - You can’t since “unknown” is not an actual language. That’s just what Plex shows when the language field is blank. There isn’t a way to look for blanks but you can look for not something like in my example above. “Not English” will show unknown. 2 - See comment above. 3 - It doesn’t do that. Maybe try doing a few at a time only. ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [August 31, 2020, 6:12pm UTC](https://forums.plex.tv/t/audio-stream-in-database/598514/6 "2020-08-31T18:12:04Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.