albums_artists

7 rows where artist_id = 3310

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4532 4532 4317 4317 3310 3310
7992 7992 7680 7680 3310 3310
8959 8959 8619 8619 3310 3310
10702 10702 10367 10367 3310 3310
12157 12157 11818 11818 3310 3310
14447 14447 14090 14090 3310 3310
27112 27112 26954 26954 3310 3310

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