albums_artists

18 rows where artist_id = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8 8 9 9 7 7
9 9 10 10 7 7
10 10 11 11 7 7
746 746 709 709 7 7
1754 1754 1655 1655 7 7
2106 2106 1977 1977 7 7
2107 2107 1978 1978 7 7
3926 3926 3723 3723 7 7
4312 4312 4108 4108 7 7
6020 6020 5749 5749 7 7
6149 6149 5869 5869 7 7
6492 6492 6201 6201 7 7
6717 6717 6426 6426 7 7
7187 7187 6888 6888 7 7
8314 8314 7993 7993 7 7
10033 10033 9689 9689 7 7
26916 26916 26772 26772 7 7
27304 27304 27137 27137 7 7

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