albums_artists

8 rows where artist_id = 4753

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7697 7697 7391 7391 4753 4753
10029 10029 9685 9685 4753 4753
15038 15038 14691 14691 4753 4753
15039 15039 14692 14692 4753 4753
16157 16157 15834 15834 4753 4753
18604 18604 18352 18352 4753 4753
20689 20689 20527 20527 4753 4753
24322 24322 24210 24210 4753 4753

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