albums_artists

5 rows where artist_id = 2340

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2859 2859 2692 2692 2340 2340
6292 6292 6006 6006 2340 2340
10203 10203 9864 9864 2340 2340
12885 12885 12542 12542 2340 2340
26749 26749 26618 26618 2340 2340

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