albums_artists

6 rows where artist_id = 3351

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4603 4603 4385 4385 3351 3351
10991 10991 10649 10649 3351 3351
13193 13193 12852 12852 3351 3351
14571 14571 14217 14217 3351 3351
15168 15168 14823 14823 3351 3351
17649 17649 17354 17354 3351 3351

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