albums_artists

8 rows where artist_id = 6900

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12744 12744 12405 12405 6900 6900
13780 13780 13424 13424 6900 6900
14397 14397 14040 14040 6900 6900
16768 16768 16460 16460 6900 6900
19519 19519 19306 19306 6900 6900
21966 21966 21866 21866 6900 6900
22952 22952 22856 22856 6900 6900
26722 26722 26593 26593 6900 6900

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