albums_artists

7 rows where artist_id = 1167

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1270 1270 1191 1191 1167 1167
3463 3463 3268 3268 1167 1167
4188 4188 3986 3986 1167 1167
17418 17418 17124 17124 1167 1167
18999 18999 18767 18767 1167 1167
24400 24400 24288 24288 1167 1167
27501 27501 27322 27322 1167 1167

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