albums_artists

6 rows where artist_id = 2059

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2427 2427 2276 2276 2059 2059
2428 2428 2277 2277 2059 2059
2814 2814 2649 2649 2059 2059
2815 2815 2650 2650 2059 2059
6922 6922 6623 6623 2059 2059
7326 7326 7030 7030 2059 2059

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