albums_artists

7 rows where artist_id = 4363

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6804 6804 6506 6506 4363 4363
9486 9486 9139 9139 4363 4363
11021 11021 10680 10680 4363 4363
12089 12089 11749 11749 4363 4363
15436 15436 15094 15094 4363 4363
15552 15552 15211 15211 4363 4363
16697 16697 16387 16387 4363 4363

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