albums_artists

7 rows where artist_id = 717

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
745 745 708 708 717 717
6618 6618 6328 6328 717 717
11395 11395 11056 11056 717 717
15397 15397 15054 15054 717 717
19535 19535 19322 19322 717 717
21508 21508 21387 21387 717 717
22512 22512 22417 22417 717 717

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