albums_artists

7 rows where artist_id = 9046

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18746 18746 18503 18503 9046 9046
19083 19083 18859 18859 9046 9046
21246 21246 21122 21122 9046 9046
23239 23239 23135 23135 9046 9046
23743 23743 23633 23633 9046 9046
25607 25607 25509 25509 9046 9046
26082 26082 25978 25978 9046 9046

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