albums_artists

10 rows where artist_id = 1522

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1699 1699 1601 1601 1522 1522
3765 3765 3566 3566 1522 1522
6420 6420 6128 6128 1522 1522
7673 7673 7367 7367 1522 1522
9929 9929 9583 9583 1522 1522
10362 10362 10021 10021 1522 1522
11186 11186 10848 10848 1522 1522
12141 12141 11802 11802 1522 1522
13304 13304 12957 12957 1522 1522
27079 27079 26923 26923 1522 1522

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