albums_artists

7 rows where artist_id = 3227

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4385 4385 4174 4174 3227 3227
6637 6637 6346 6346 3227 3227
8584 8584 8250 8250 3227 3227
9008 9008 8668 8668 3227 3227
10794 10794 10457 10457 3227 3227
12637 12637 12299 12299 3227 3227
15778 15778 15440 15440 3227 3227

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