albums_artists

10 rows where artist_id = 1384

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1515 1515 1429 1429 1384 1384
2439 2439 2288 2288 1384 1384
4886 4886 4660 4660 1384 1384
6257 6257 5971 5971 1384 1384
7734 7734 7427 7427 1384 1384
8887 8887 8553 8553 1384 1384
8968 8968 8628 8628 1384 1384
11126 11126 10787 10787 1384 1384
11757 11757 11415 11415 1384 1384
27528 27528 27342 27342 1384 1384

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