albums_artists

8 rows where artist_id = 5826

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10223 10223 9884 9884 5826 5826
11895 11895 11553 11553 5826 5826
20408 20408 20242 20242 5826 5826
21157 21157 21030 21030 5826 5826
22963 22963 22867 22867 5826 5826
24430 24430 24319 24319 5826 5826
25222 25222 25116 25116 5826 5826
25847 25847 25748 25748 5826 5826

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE albums_artists (
	album_id integer NOT NULL,
	artist_id integer NOT NULL,
	FOREIGN KEY(artist_id) REFERENCES artists(id),
	FOREIGN KEY(album_id) REFERENCES albums(id),
	UNIQUE(album_id, artist_id)
);