tunes-medialibrary.0.2.2.source-code.album_tracks.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of itunes-medialibrary Show documentation

Java library for reading/writing to the iTunes MediaLibrary SQLite database

The newest version!

SELECT
    album_artist.album_artist,
    album.album,
    item_extra.title,
    item_artist.item_artist,
    item_extra.year,
    item_extra.location,
    item.item_pid
FROM
	item
INNER JOIN item_artist ON item.item_artist_pid = item_artist.item_artist_pid
INNER JOIN item_extra ON item_extra.item_pid = item.item_pid
INNER JOIN album ON album.album_pid = item.album_pid
INNER JOIN album_artist ON album.album_artist_pid = album_artist.album_artist_pid
INNER JOIN item_video ON item_video.item_pid = item.item_pid