albums_artists

7 rows where artist_id = 1422

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1568 1568 1479 1479 1422 1422
3554 3554 3357 3357 1422 1422
5660 5660 5397 5397 1422 1422
7509 7509 7204 7204 1422 1422
9751 9751 9405 9405 1422 1422
10237 10237 9898 9898 1422 1422
27136 27136 26977 26977 1422 1422

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