albums_artists

5 rows where artist_id = 6648

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12110 12110 11771 11771 6648 6648
13560 13560 13208 13208 6648 6648
13561 13561 13209 13209 6648 6648
15570 15570 15228 15228 6648 6648
15987 15987 15648 15648 6648 6648

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)
);