albums_artists

8 rows where artist_id = 500

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
513 513 492 492 500 500
1406 1406 1323 1323 500 500
1407 1407 1324 1324 500 500
2524 2524 2372 2372 500 500
3102 3102 2924 2924 500 500
3629 3629 3433 3433 500 500
5338 5338 5088 5088 500 500
27236 27236 27075 27075 500 500

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