albums_artists

5 rows where artist_id = 2427

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3014 3014 2841 2841 2427 2427
5619 5619 5358 5358 2427 2427
6825 6825 6528 6528 2427 2427
8016 8016 7703 7703 2427 2427
9240 9240 8895 8895 2427 2427

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