albums_artists

11 rows where artist_id = 5322

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9093 9093 8752 8752 5322 5322
11798 11798 11457 11457 5322 5322
12408 12408 12071 12071 5322 5322
17457 17457 17163 17163 5322 5322
17458 17458 17164 17164 5322 5322
17459 17459 17165 17165 5322 5322
17460 17460 17166 17166 5322 5322
17461 17461 17167 17167 5322 5322
20987 20987 20842 20842 5322 5322
21872 21872 21768 21768 5322 5322
25442 25442 25342 25342 5322 5322

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