albums_artists

12 rows where artist_id = 1272

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1382 1382 1301 1301 1272 1272
4228 4228 4027 4027 1272 1272
13358 13358 13007 13007 1272 1272
17003 17003 16695 16695 1272 1272
18726 18726 18482 18482 1272 1272
21301 21301 21177 21177 1272 1272
22780 22780 22690 22690 1272 1272
23024 23024 22928 22928 1272 1272
23456 23456 23350 23350 1272 1272
23769 23769 23660 23660 1272 1272
24462 24462 24350 24350 1272 1272
24632 24632 24510 24510 1272 1272

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