albums_artists

7 rows where artist_id = 1055

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1116 1116 1054 1054 1055 1055
3648 3648 3452 3452 1055 1055
4788 4788 4571 4571 1055 1055
5219 5219 4974 4974 1055 1055
9742 9742 9396 9396 1055 1055
11644 11644 11307 11307 1055 1055
27091 27091 26935 26935 1055 1055

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