albums_artists

5 rows where artist_id = 7754

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15224 15224 14879 14879 7754 7754
16807 16807 16498 16498 7754 7754
22135 22135 22039 22039 7754 7754
23162 23162 23061 23061 7754 7754
25779 25779 25680 25680 7754 7754

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