albums_artists

8 rows where artist_id = 1542

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1723 1723 1624 1624 1542 1542
4998 4998 4761 4761 1542 1542
9861 9861 9515 9515 1542 1542
12192 12192 11855 11855 1542 1542
15672 15672 15334 15334 1542 1542
17213 17213 16909 16909 1542 1542
18745 18745 18502 18502 1542 1542
21380 21380 21258 21258 1542 1542

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