albums_artists

11 rows where artist_id = 3147

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4250 4250 4049 4049 3147 3147
12198 12198 11860 11860 3147 3147
12607 12607 12269 12269 3147 3147
15207 15207 14861 14861 3147 3147
18227 18227 17948 17948 3147 3147
19206 19206 18985 18985 3147 3147
19943 19943 19755 19755 3147 3147
22582 22582 22488 22488 3147 3147
25216 25216 25109 25109 3147 3147
26061 26061 25962 25962 3147 3147
26386 26386 26280 26280 3147 3147

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