albums_artists

6 rows where artist_id = 1482

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1641 1641 1549 1549 1482 1482
4630 4630 4412 4412 1482 1482
5388 5388 5136 5136 1482 1482
6599 6599 6310 6310 1482 1482
6905 6905 6606 6606 1482 1482
27614 27614 27423 27423 1482 1482

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