albums_artists

6 rows where artist_id = 4289

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6647 6647 6356 6356 4289 4289
8157 8157 7838 7838 4289 4289
19390 19390 19174 19174 4289 4289
25275 25275 25172 25172 4289 4289
26380 26380 26274 26274 4289 4289
26381 26381 26275 26275 4289 4289

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