albums_artists

6 rows where artist_id = 6244

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11127 11127 10788 10788 6244 6244
13092 13092 12755 12755 6244 6244
16872 16872 16562 16562 6244 6244
19427 19427 19211 19211 6244 6244
20771 20771 20613 20613 6244 6244
21696 21696 21585 21585 6244 6244

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