albums_artists

8 rows where artist_id = 6384

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11470 11470 11133 11133 6384 6384
15970 15970 15631 15631 6384 6384
20663 20663 20501 20501 6384 6384
23662 23662 23555 23555 6384 6384
25510 25510 25410 25410 6384 6384
25629 25629 25531 25531 6384 6384
26260 26260 26158 26158 6384 6384
26519 26519 26408 26408 6384 6384

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