albums_artists

7 rows where artist_id = 3064

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4097 4097 3898 3898 3064 3064
8805 8805 8472 8472 3064 3064
11719 11719 11377 11377 3064 3064
13019 13019 12678 12678 3064 3064
16275 16275 15959 15959 3064 3064
18856 18856 18613 18613 3064 3064
27152 27152 26993 26993 3064 3064

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