albums_artists

6 rows where artist_id = 972

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1023 1023 967 967 972 972
2501 2501 2350 2350 972 972
6248 6248 5963 5963 972 972
6984 6984 6685 6685 972 972
9539 9539 9194 9194 972 972
10650 10650 10317 10317 972 972

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