albums_artists

6 rows where artist_id = 6609

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12017 12017 11676 11676 6609 6609
13048 13048 12710 12710 6609 6609
13049 13049 12711 12711 6609 6609
13050 13050 12712 12712 6609 6609
14029 14029 13675 13675 6609 6609
17274 17274 16971 16971 6609 6609

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