albums_artists

6 rows where artist_id = 1164

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1267 1267 1189 1189 1164 1164
2005 2005 1886 1886 1164 1164
2883 2883 2714 2714 1164 1164
3351 3351 3165 3165 1164 1164
3959 3959 3755 3755 1164 1164
26940 26940 26795 26795 1164 1164

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