albums_artists

8 rows where artist_id = 273

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
280 280 268 268 273 273
16702 16702 16392 16392 273 273
18439 18439 18168 18168 273 273
20073 20073 19891 19891 273 273
21089 21089 20954 20954 273 273
21987 21987 21887 21887 273 273
23883 23883 23771 23771 273 273
24892 24892 24782 24782 273 273

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