albums_artists

5 rows where artist_id = 3026

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4032 4032 3831 3831 3026 3026
5173 5173 4931 4931 3026 3026
8080 8080 7766 7766 3026 3026
11337 11337 11001 11001 3026 3026
14119 14119 13764 13764 3026 3026

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