albums_artists

7 rows where artist_id = 1119

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1215 1215 1145 1145 1119 1119
2771 2771 2606 2606 1119 1119
7412 7412 7112 7112 1119 1119
8257 8257 7938 7938 1119 1119
9288 9288 8942 8942 1119 1119
11551 11551 11213 11213 1119 1119
27012 27012 26862 26862 1119 1119

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