albums_artists

7 rows where artist_id = 1148

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1250 1250 1175 1175 1148 1148
5629 5629 5367 5367 1148 1148
8161 8161 7842 7842 1148 1148
9647 9647 9300 9300 1148 1148
11087 11087 10747 10747 1148 1148
11778 11778 11438 11438 1148 1148
27107 27107 26950 26950 1148 1148

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