albums_artists

7 rows where artist_id = 3493

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4891 4891 4664 4664 3493 3493
7045 7045 6748 6748 3493 3493
9103 9103 8763 8763 3493 3493
11649 11649 11312 11312 3493 3493
13508 13508 13157 13157 3493 3493
13936 13936 13578 13578 3493 3493
27616 27616 27425 27425 3493 3493

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