albums_artists

5 rows where artist_id = 3391

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4670 4670 4453 4453 3391 3391
12186 12186 11849 11849 3391 3391
14533 14533 14177 14177 3391 3391
15512 15512 15171 15171 3391 3391
16457 16457 16144 16144 3391 3391

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