albums_artists

10 rows where artist_id = 5123

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8606 8606 8273 8273 5123 5123
11502 11502 11165 11165 5123 5123
14491 14491 14135 14135 5123 5123
15012 15012 14665 14665 5123 5123
16284 16284 15968 15968 5123 5123
17739 17739 17444 17444 5123 5123
18779 18779 18537 18537 5123 5123
19605 19605 19398 19398 5123 5123
20486 20486 20322 20322 5123 5123
22001 22001 21901 21901 5123 5123

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