albums_artists

11 rows where artist_id = 354

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
362 362 345 345 354 354
1360 1360 1280 1280 354 354
2348 2348 2202 2202 354 354
3541 3541 3344 3344 354 354
5045 5045 4806 4806 354 354
5830 5830 5564 5564 354 354
7137 7137 6838 6838 354 354
11204 11204 10866 10866 354 354
12547 12547 12207 12207 354 354
15178 15178 14833 14833 354 354
26846 26846 26707 26707 354 354

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