Where is the album artist tag in the Plex SQLite database?

[thunderousleader10]

So I’ve just delved into Plex’s SQLite database for the first time as I want to import all my iTunes ratings into Plex. When I go to ‘metadata_items’ I can see a bunch of useful info about my files, however, a lot of the core fields i’m interested in, including album artist, album etc don’t appear here. It seems as though this table is more geared towards movies and not music. Am I looking in the wrong database or table?

Any help would be amazing!

[LtColDoerk]

First of all, you can import iTunes playlists and ratings in PLEX playlists.

Maybe this SQL statement will put you on the right track:

select
mi3.id AS TrackID,
mi2.id AS AlbumID,
mi2.parent_id AS ArtistID,
mi1.title AS Artist,
mi2.title AS Album,
mi3.title AS Track,
mi3.title_sort AS TrackSort,
mi3.absolute_index AS Disc,
mi3.“index” AS TrackNo,
mi2.studio,
mi3.“year”,
mi3.content_rating,
ms.rating
from
metadata_items AS mi1
inner join metadata_items AS mi2 ON mi2.parent_id = mi1.id
inner join metadata_items AS mi3 ON mi3.parent_id = mi2.id
INNER JOIN metadata_item_settings AS ms ON (mi3.guid = ms.guid) AND (ms.account_id = 1)
where
Artist LIKE “%Bruno Mars%” AND
Album LIKE “%%” AND
Track LIKE “%%”
order by artist, album, disc, TrackNo