albums_artists

7 rows where artist_id = 397

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
406 406 389 389 397 397
1557 1557 1468 1468 397 397
1810 1810 1710 1710 397 397
3259 3259 3076 3076 397 397
4268 4268 4065 4065 397 397
5196 5196 4952 4952 397 397
26590 26590 26476 26476 397 397

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