albums_artists

10 rows where artist_id = 3361

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4616 4616 4398 4398 3361 3361
6489 6489 6198 6198 3361 3361
10837 10837 10501 10501 3361 3361
15042 15042 14695 14695 3361 3361
15658 15658 15320 15320 3361 3361
16405 16405 16091 16091 3361 3361
18785 18785 18543 18543 3361 3361
19482 19482 19267 19267 3361 3361
19938 19938 19750 19750 3361 3361
22073 22073 21977 21977 3361 3361

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