albums_artists

5 rows where artist_id = 9168

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
19093 19093 18869 18869 9168 9168
20329 20329 20159 20159 9168 9168
21478 21478 21359 21359 9168 9168
22405 22405 22311 22311 9168 9168
26164 26164 26062 26062 9168 9168

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