albums_artists

5 rows where artist_id = 1142

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1243 1243 1169 1169 1142 1142
2706 2706 2544 2544 1142 1142
5183 5183 4940 4940 1142 1142
6604 6604 6315 6315 1142 1142
26830 26830 26692 26692 1142 1142

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