albums_artists

11 rows where artist_id = 6964

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12947 12947 12603 12603 6964 6964
12948 12948 12604 12604 6964 6964
12949 12949 12605 12605 6964 6964
12950 12950 12606 12606 6964 6964
12951 12951 12607 12607 6964 6964
12952 12952 12608 12608 6964 6964
15441 15441 15099 15099 6964 6964
20667 20667 20505 20505 6964 6964
21853 21853 21749 21749 6964 6964
23548 23548 23444 23444 6964 6964
24823 24823 24706 24706 6964 6964

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