albums_artists

7 rows where artist_id = 7465

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14371 14371 14012 14012 7465 7465
19534 19534 19321 19321 7465 7465
22070 22070 21974 21974 7465 7465
22637 22637 22546 22546 7465 7465
24581 24581 24459 24459 7465 7465
25979 25979 25880 25880 7465 7465
26043 26043 25943 25943 7465 7465

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