albums_artists

12 rows where artist_id = 1674

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1895 1895 1788 1788 1674 1674
5223 5223 4978 4978 1674 1674
5224 5224 4979 4979 1674 1674
5225 5225 4980 4980 1674 1674
5226 5226 4981 4981 1674 1674
5227 5227 4982 4982 1674 1674
7819 7819 7507 7507 1674 1674
15596 15596 15257 15257 1674 1674
21424 21424 21302 21302 1674 1674
23421 23421 23316 23316 1674 1674
25132 25132 25026 25026 1674 1674
27194 27194 27032 27032 1674 1674

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