albums_artists

5 rows where artist_id = 5392

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9255 9255 8909 8909 5392 5392
14698 14698 14343 14343 5392 5392
20520 20520 20358 20358 5392 5392
23262 23262 23160 23160 5392 5392
25941 25941 25842 25842 5392 5392

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