albums_artists

9 rows where artist_id = 1653

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1871 1871 1765 1765 1653 1653
3661 3661 3465 3465 1653 1653
4809 4809 4591 4591 1653 1653
5617 5617 5357 5357 1653 1653
6395 6395 6105 6105 1653 1653
8138 8138 7819 7819 1653 1653
8917 8917 8581 8581 1653 1653
8918 8918 8582 8582 1653 1653
17176 17176 16872 16872 1653 1653

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