albums_artists

10 rows where artist_id = 2126

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2535 2535 2383 2383 2126 2126
3810 3810 3608 3608 2126 2126
6093 6093 5816 5816 2126 2126
6950 6950 6652 6652 2126 2126
10202 10202 9863 9863 2126 2126
12752 12752 12411 12411 2126 2126
14431 14431 14075 14075 2126 2126
17867 17867 17574 17574 2126 2126
18864 18864 18621 18621 2126 2126
20602 20602 20438 20438 2126 2126

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