albums_artists

7 rows where artist_id = 3769

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5488 5488 5232 5232 3769 3769
11327 11327 10989 10989 3769 3769
14124 14124 13769 13769 3769 3769
15807 15807 15465 15465 3769 3769
16971 16971 16663 16663 3769 3769
17773 17773 17481 17481 3769 3769
18776 18776 18534 18534 3769 3769

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