albums_artists

6 rows where artist_id = 1353

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1480 1480 1396 1396 1353 1353
7744 7744 7437 7437 1353 1353
8839 8839 8508 8508 1353 1353
15814 15814 15472 15472 1353 1353
18010 18010 17720 17720 1353 1353
23560 23560 23456 23456 1353 1353

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