albums_artists

13 rows where artist_id = 1693

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1920 1920 1809 1809 1693 1693
7942 7942 7628 7628 1693 1693
12548 12548 12208 12208 1693 1693
12778 12778 12436 12436 1693 1693
16733 16733 16424 16424 1693 1693
19332 19332 19115 19115 1693 1693
20433 20433 20267 20267 1693 1693
20434 20434 20268 20268 1693 1693
20435 20435 20269 20269 1693 1693
21831 21831 21728 21728 1693 1693
21832 21832 21729 21729 1693 1693
21833 21833 21730 21730 1693 1693
26069 26069 25970 25970 1693 1693

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