albums_artists

16 rows where artist_id = 1988

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2332 2332 2188 2188 1988 1988
4822 4822 4603 4603 1988 1988
10031 10031 9687 9687 1988 1988
10296 10296 9955 9955 1988 1988
11754 11754 11412 11412 1988 1988
12507 12507 12168 12168 1988 1988
13014 13014 12673 12673 1988 1988
13104 13104 12766 12766 1988 1988
13794 13794 13438 13438 1988 1988
13795 13795 13439 13439 1988 1988
19099 19099 18875 18875 1988 1988
24460 24460 24348 24348 1988 1988
26107 26107 26003 26003 1988 1988
26163 26163 26061 26061 1988 1988
26790 26790 26656 26656 1988 1988
27105 27105 26948 26948 1988 1988

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