albums_artists

16 rows where artist_id = 530

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
545 545 522 522 530 530
3021 3021 2847 2847 530 530
4399 4399 4188 4188 530 530
5576 5576 5317 5317 530 530
11160 11160 10821 10821 530 530
13541 13541 13190 13190 530 530
15619 15619 15281 15281 530 530
17058 17058 16755 16755 530 530
19892 19892 19703 19703 530 530
21830 21830 21727 21727 530 530
23667 23667 23560 23560 530 530
24074 24074 23964 23964 530 530
25149 25149 25044 25044 530 530
25922 25922 25824 25824 530 530
26014 26014 25915 25915 530 530
26384 26384 26278 26278 530 530

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