albums_artists

12 rows where artist_id = 999

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1054 1054 997 997 999 999
4515 4515 4298 4298 999 999
5907 5907 5638 5638 999 999
6765 6765 6471 6471 999 999
7907 7907 7591 7591 999 999
8539 8539 8206 8206 999 999
8667 8667 8332 8332 999 999
9213 9213 8870 8870 999 999
10732 10732 10398 10398 999 999
11533 11533 11195 11195 999 999
12862 12862 12519 12519 999 999
27423 27423 27250 27250 999 999

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