albums_artists

8 rows where artist_id = 330

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
337 337 321 321 330 330
1204 1204 1134 1134 330 330
6180 6180 5901 5901 330 330
8502 8502 8169 8169 330 330
9195 9195 8853 8853 330 330
9599 9599 9254 9254 330 330
10399 10399 10058 10058 330 330
11647 11647 11310 11310 330 330

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