albums_artists

5 rows where artist_id = 7093

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13318 13318 12971 12971 7093 7093
15294 15294 14950 14950 7093 7093
17759 17759 17465 17465 7093 7093
21270 21270 21146 21146 7093 7093
23829 23829 23719 23719 7093 7093

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