albums_artists

10 rows where artist_id = 2504

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3132 3132 2954 2954 2504 2504
8136 8136 7817 7817 2504 2504
10992 10992 10650 10650 2504 2504
12428 12428 12090 12090 2504 2504
12796 12796 12454 12454 2504 2504
13341 13341 12992 12992 2504 2504
14102 14102 13747 13747 2504 2504
14218 14218 13857 13857 2504 2504
15002 15002 14654 14654 2504 2504
15421 15421 15078 15078 2504 2504

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