albums_artists

6 rows where artist_id = 7027

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13144 13144 12805 12805 7027 7027
18650 18650 18401 18401 7027 7027
22705 22705 22613 22613 7027 7027
22726 22726 22634 22634 7027 7027
25058 25058 24953 24953 7027 7027
27050 27050 26900 26900 7027 7027

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