albums_artists

7 rows where artist_id = 684

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
709 709 676 676 684 684
2313 2313 2170 2170 684 684
3005 3005 2832 2832 684 684
3265 3265 3082 3082 684 684
4070 4070 3870 3870 684 684
4713 4713 4497 4497 684 684
27232 27232 27071 27071 684 684

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