albums_artists

14 rows where artist_id = 1833

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2114 2114 1984 1984 1833 1833
5667 5667 5403 5403 1833 1833
10065 10065 9719 9719 1833 1833
11215 11215 10877 10877 1833 1833
12613 12613 12275 12275 1833 1833
13534 13534 13182 13182 1833 1833
20087 20087 19906 19906 1833 1833
21185 21185 21058 21058 1833 1833
22572 22572 22478 22478 1833 1833
24080 24080 23970 23970 1833 1833
24254 24254 24145 24145 1833 1833
25328 25328 25227 25227 1833 1833
25730 25730 25630 25630 1833 1833
26142 26142 26039 26039 1833 1833

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