albums_artists

7 rows where artist_id = 181

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
186 186 179 179 181 181
874 874 827 827 181 181
7963 7963 7648 7648 181 181
8121 8121 7803 7803 181 181
14100 14100 13745 13745 181 181
20470 20470 20305 20305 181 181
26315 26315 26211 26211 181 181

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