albums_artists

13 rows where artist_id = 451

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
462 462 442 442 451 451
7107 7107 6809 6809 451 451
12153 12153 11814 11814 451 451
14377 14377 14019 14019 451 451
16951 16951 16643 16643 451 451
19808 19808 19613 19613 451 451
20232 20232 20056 20056 451 451
20233 20233 20057 20057 451 451
20234 20234 20058 20058 451 451
21145 21145 21017 21017 451 451
22309 22309 22219 22219 451 451
25718 25718 25618 25618 451 451
26633 26633 26516 26516 451 451

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