albums_artists

7 rows where artist_id = 351

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
359 359 342 342 351 351
3247 3247 3064 3064 351 351
8240 8240 7920 7920 351 351
12439 12439 12100 12100 351 351
14552 14552 14197 14197 351 351
15976 15976 15637 15637 351 351
19166 19166 18945 18945 351 351

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