albums_artists

9 rows where artist_id = 200

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
205 205 198 198 200 200
431 431 411 411 200 200
1064 1064 1007 1007 200 200
1156 1156 1088 1088 200 200
1415 1415 1331 1331 200 200
3068 3068 2893 2893 200 200
5579 5579 5320 5320 200 200
6314 6314 6028 6028 200 200
6549 6549 6260 6260 200 200

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