albums_artists

7 rows where artist_id = 1552

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1734 1734 1635 1635 1552 1552
3058 3058 2883 2883 1552 1552
5024 5024 4786 4786 1552 1552
10102 10102 9759 9759 1552 1552
11946 11946 11603 11603 1552 1552
12475 12475 12138 12138 1552 1552
13283 13283 12938 12938 1552 1552

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