albums_artists

9 rows where artist_id = 2473

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3081 3081 2904 2904 2473 2473
20227 20227 20051 20051 2473 2473
24854 24854 24740 24740 2473 2473
24855 24855 24741 24741 2473 2473
24856 24856 24742 24742 2473 2473
25106 25106 25003 25003 2473 2473
26037 26037 25938 25938 2473 2473
26187 26187 26085 26085 2473 2473
26389 26389 26283 26283 2473 2473

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