albums_artists

7 rows where artist_id = 1740

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1985 1985 1870 1870 1740 1740
3279 3279 3096 3096 1740 1740
6418 6418 6126 6126 1740 1740
9713 9713 9366 9366 1740 1740
12696 12696 12356 12356 1740 1740
24574 24574 24453 24453 1740 1740
25879 25879 25781 25781 1740 1740

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