albums_artists

8 rows where artist_id = 1901

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2205 2205 2069 2069 1901 1901
11032 11032 10691 10691 1901 1901
16061 16061 15733 15733 1901 1901
17963 17963 17671 17671 1901 1901
23268 23268 23166 23166 1901 1901
23643 23643 23539 23539 1901 1901
23909 23909 23794 23794 1901 1901
25259 25259 25157 25157 1901 1901

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