albums_artists

5 rows where artist_id = 1333

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1454 1454 1370 1370 1333 1333
9454 9454 9107 9107 1333 1333
13567 13567 13215 13215 1333 1333
17171 17171 16867 16867 1333 1333
20103 20103 19924 19924 1333 1333

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