albums_artists

9 rows where artist_id = 345

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
352 352 336 336 345 345
1664 1664 1570 1570 345 345
4837 4837 4617 4617 345 345
9465 9465 9118 9118 345 345
12739 12739 12400 12400 345 345
16455 16455 16142 16142 345 345
18192 18192 17910 17910 345 345
20286 20286 20113 20113 345 345
26235 26235 26133 26133 345 345

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