albums_artists

6 rows where artist_id = 1834

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2115 2115 1985 1985 1834 1834
3911 3911 3707 3707 1834 1834
7135 7135 6836 6836 1834 1834
9553 9553 9208 9208 1834 1834
12987 12987 12644 12644 1834 1834
14308 14308 13950 13950 1834 1834

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