albums_artists

5 rows where artist_id = 2052

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2419 2419 2268 2268 2052 2052
13786 13786 13430 13430 2052 2052
15182 15182 14837 14837 2052 2052
17215 17215 16912 16912 2052 2052
17216 17216 16913 16913 2052 2052

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