albums_artists

8 rows where artist_id = 1798

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2061 2061 1938 1938 1798 1798
5639 5639 5376 5376 1798 1798
9832 9832 9485 9485 1798 1798
14856 14856 14508 14508 1798 1798
21167 21167 21040 21040 1798 1798
21713 21713 21602 21602 1798 1798
24338 24338 24225 24225 1798 1798
24339 24339 24226 24226 1798 1798

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