albums_artists

7 rows where artist_id = 4767

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7735 7735 7428 7428 4767 4767
10072 10072 9729 9729 4767 4767
10923 10923 10582 10582 4767 4767
11487 11487 11150 11150 4767 4767
13662 13662 13311 13311 4767 4767
14223 14223 13862 13862 4767 4767
22245 22245 22155 22155 4767 4767

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