albums_artists

9 rows where artist_id = 46

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
51 51 50 50 46 46
3542 3542 3345 3345 46 46
6388 6388 6098 6098 46 46
6587 6587 6299 6299 46 46
7394 7394 7094 7094 46 46
10016 10016 9671 9671 46 46
10682 10682 10348 10348 46 46
16119 16119 15791 15791 46 46
27573 27573 27384 27384 46 46

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