albums_artists

7 rows where artist_id = 356

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
364 364 346 346 356 356
2992 2992 2820 2820 356 356
4693 4693 4476 4476 356 356
6359 6359 6069 6069 356 356
7784 7784 7474 7474 356 356
8405 8405 8079 8079 356 356
9975 9975 9630 9630 356 356

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