albums_artists

7 rows where artist_id = 5350

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9172 9172 8829 8829 5350 5350
9173 9173 8830 8830 5350 5350
10218 10218 9879 9879 5350 5350
10981 10981 10639 10639 5350 5350
11398 11398 11059 11059 5350 5350
25746 25746 25646 25646 5350 5350
26251 26251 26148 26148 5350 5350

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