albums_artists

9 rows where artist_id = 704

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
730 730 697 697 704 704
1934 1934 1823 1823 704 704
4684 4684 4468 4468 704 704
9455 9455 9108 9108 704 704
10699 10699 10363 10363 704 704
12506 12506 12167 12167 704 704
13627 13627 13276 13276 704 704
15185 15185 14840 14840 704 704
16731 16731 16422 16422 704 704

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