albums_artists

10 rows where artist_id = 3320

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4551 4551 4335 4335 3320 3320
5370 5370 5118 5118 3320 3320
11513 11513 11176 11176 3320 3320
13698 13698 13347 13347 3320 3320
14015 14015 13661 13661 3320 3320
16249 16249 15927 15927 3320 3320
16250 16250 15928 15928 3320 3320
21115 21115 20981 20981 3320 3320
22238 22238 22148 22148 3320 3320
24524 24524 24405 24405 3320 3320

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