albums_artists

7 rows where artist_id = 129

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
134 134 130 130 129 129
1391 1391 1309 1309 129 129
1831 1831 1730 1730 129 129
3607 3607 3412 3412 129 129
6499 6499 6207 6207 129 129
8799 8799 8466 8466 129 129
27178 27178 27017 27017 129 129

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