albums_artists

10 rows where artist_id = 318

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
325 325 311 311 318 318
1143 1143 1078 1078 318 318
1456 1456 1372 1372 318 318
2573 2573 2421 2421 318 318
4159 4159 3958 3958 318 318
5095 5095 4852 4852 318 318
5670 5670 5406 5406 318 318
7117 7117 6819 6819 318 318
7488 7488 7184 7184 318 318
27309 27309 27141 27141 318 318

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