albums_artists

12 rows where artist_id = 375

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
383 383 364 364 375 375
4115 4115 3915 3915 375 375
9529 9529 9184 9184 375 375
13135 13135 12796 12796 375 375
15287 15287 14942 14942 375 375
16017 16017 15682 15682 375 375
16759 16759 16450 16450 375 375
17261 17261 16958 16958 375 375
18444 18444 18175 18175 375 375
19250 19250 19031 19031 375 375
20411 20411 20245 20245 375 375
21012 21012 20868 20868 375 375

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