albums_artists

7 rows where artist_id = 2684

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3426 3426 3233 3233 2684 2684
4533 4533 4317 4317 2684 2684
16161 16161 15838 15838 2684 2684
19030 19030 18801 18801 2684 2684
19762 19762 19566 19566 2684 2684
22258 22258 22167 22167 2684 2684
27404 27404 27230 27230 2684 2684

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