albums_artists

5 rows where artist_id = 1153

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1255 1255 1179 1179 1153 1153
4367 4367 4159 4159 1153 1153
4834 4834 4614 4614 1153 1153
8761 8761 8429 8429 1153 1153
9069 9069 8729 8729 1153 1153

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