albums_artists

5 rows where artist_id = 1324

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1444 1444 1360 1360 1324 1324
14663 14663 14308 14308 1324 1324
17083 17083 16781 16781 1324 1324
18396 18396 18125 18125 1324 1324
19079 19079 18855 18855 1324 1324

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