albums_artists

8 rows where artist_id = 1318

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1437 1437 1353 1353 1318 1318
2645 2645 2487 2487 1318 1318
7316 7316 7020 7020 1318 1318
8015 8015 7702 7702 1318 1318
11085 11085 10745 10745 1318 1318
13090 13090 12753 12753 1318 1318
13091 13091 12754 12754 1318 1318
14945 14945 14594 14594 1318 1318

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