albums_artists

12 rows where artist_id = 883

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
923 923 874 874 883 883
1767 1767 1667 1667 883 883
3015 3015 2842 2842 883 883
3980 3980 3776 3776 883 883
5713 5713 5450 5450 883 883
6079 6079 5803 5803 883 883
7123 7123 6824 6824 883 883
7980 7980 7666 7666 883 883
8767 8767 8435 8435 883 883
9488 9488 9141 9141 883 883
12483 12483 12145 12145 883 883
26859 26859 26718 26718 883 883

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