albums_artists

4 rows where artist_id = 3302

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4520 4520 4303 4303 3302 3302
7696 7696 7390 7390 3302 3302
12538 12538 12198 12198 3302 3302
17647 17647 17352 17352 3302 3302

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