albums_artists

8 rows where artist_id = 6912

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12780 12780 12438 12438 6912 6912
21764 21764 21656 21656 6912 6912
21901 21901 21797 21797 6912 6912
23299 23299 23195 23195 6912 6912
23300 23300 23196 23196 6912 6912
24573 24573 24452 24452 6912 6912
25623 25623 25525 25525 6912 6912
26344 26344 26238 26238 6912 6912

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