albums_artists

13 rows where artist_id = 4396

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6868 6868 6569 6569 4396 4396
12214 12214 11878 11878 4396 4396
14650 14650 14295 14295 4396 4396
15634 15634 15296 15296 4396 4396
15950 15950 15611 15611 4396 4396
18062 18062 17773 17773 4396 4396
18157 18157 17873 17873 4396 4396
18920 18920 18679 18679 4396 4396
20492 20492 20328 20328 4396 4396
21585 21585 21471 21471 4396 4396
22482 22482 22386 22386 4396 4396
22483 22483 22387 22387 4396 4396
23430 23430 23326 23326 4396 4396

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