albums_artists

6 rows where artist_id = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15 15 15 15 10 10
2290 2290 2147 2147 10 10
3288 3288 3105 3105 10 10
6206 6206 5926 5926 10 10
8478 8478 8149 8149 10 10
27247 27247 27085 27085 10 10

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