albums_artists

5 rows where artist_id = 6549

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11876 11876 11534 11534 6549 6549
11877 11877 11535 11535 6549 6549
11878 11878 11536 11536 6549 6549
20420 20420 20254 20254 6549 6549
22211 22211 22119 22119 6549 6549

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