albums_artists

5 rows where artist_id = 6405

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11537 11537 11199 11199 6405 6405
13768 13768 13413 13413 6405 6405
14572 14572 14218 14218 6405 6405
17485 17485 17191 17191 6405 6405
18056 18056 17766 17766 6405 6405

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