albums_artists

7 rows where artist_id = 10051

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
21773 21773 21667 21667 10051 10051
23655 23655 23548 23548 10051 10051
23792 23792 23682 23682 10051 10051
24372 24372 24259 24259 10051 10051
24791 24791 24675 24675 10051 10051
25583 25583 25485 25485 10051 10051
25673 25673 25573 25573 10051 10051

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