albums_artists

5 rows where artist_id = 2331

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2844 2844 2677 2677 2331 2331
2845 2845 2678 2678 2331 2331
2846 2846 2679 2679 2331 2331
12879 12879 12536 12536 2331 2331
25334 25334 25234 25234 2331 2331

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