albums_artists

10 rows where artist_id = 2543

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3182 3182 3003 3003 2543 2543
11439 11439 11100 11100 2543 2543
14629 14629 14274 14274 2543 2543
14630 14630 14275 14275 2543 2543
14631 14631 14276 14276 2543 2543
16430 16430 16116 16116 2543 2543
17021 17021 16717 16717 2543 2543
20498 20498 20334 20334 2543 2543
22266 22266 22175 22175 2543 2543
24439 24439 24328 24328 2543 2543

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