albums_artists

7 rows where artist_id = 2301

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2797 2797 2632 2632 2301 2301
14746 14746 14392 14392 2301 2301
17588 17588 17292 17292 2301 2301
20581 20581 20420 20420 2301 2301
22894 22894 22800 22800 2301 2301
24739 24739 24620 24620 2301 2301
27251 27251 27088 27088 2301 2301

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