albums_artists

6 rows where artist_id = 1141

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1242 1242 1168 1168 1141 1141
2013 2013 1894 1894 1141 1141
3032 3032 2857 2857 1141 1141
5439 5439 5183 5183 1141 1141
7831 7831 7519 7519 1141 1141
27536 27536 27350 27350 1141 1141

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