albums_artists

18 rows where artist_id = 978

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1030 1030 974 974 978 978
2834 2834 2668 2668 978 978
3760 3760 3561 3561 978 978
6672 6672 6381 6381 978 978
8496 8496 8166 8166 978 978
10619 10619 10285 10285 978 978
13802 13802 13447 13447 978 978
14441 14441 14085 14085 978 978
14442 14442 14086 14086 978 978
15189 15189 14845 14845 978 978
15480 15480 15139 15139 978 978
18130 18130 17846 17846 978 978
19693 19693 19494 19494 978 978
20264 20264 20089 20089 978 978
20924 20924 20775 20775 978 978
20964 20964 20819 20819 978 978
20965 20965 20820 20820 978 978
20967 20967 20821 20821 978 978

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