albums_artists

11 rows where artist_id = 1206

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1312 1312 1233 1233 1206 1206
6407 6407 6115 6115 1206 1206
7046 7046 6749 6749 1206 1206
10592 10592 10254 10254 1206 1206
11260 11260 10924 10924 1206 1206
14001 14001 13646 13646 1206 1206
17032 17032 16729 16729 1206 1206
20045 20045 19862 19862 1206 1206
20749 20749 20591 20591 1206 1206
22165 22165 22071 22071 1206 1206
24685 24685 24562 24562 1206 1206

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