albums_artists

6 rows where artist_id = 7545

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14622 14622 14267 14267 7545 7545
15725 15725 15388 15388 7545 7545
17571 17571 17275 17275 7545 7545
18433 18433 18162 18162 7545 7545
19618 19618 19412 19412 7545 7545
19949 19949 19761 19761 7545 7545

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