albums_artists

9 rows where artist_id = 30

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
35 35 35 35 30 30
2508 2508 2356 2356 30 30
4876 4876 4650 4650 30 30
6089 6089 5812 5812 30 30
6246 6246 5961 5961 30 30
6601 6601 6311 6311 30 30
7998 7998 7684 7684 30 30
26878 26878 26737 26737 30 30
27624 27624 27431 27431 30 30

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