albums_artists

7 rows where artist_id = 579

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
598 598 574 574 579 579
6478 6478 6187 6187 579 579
10680 10680 10346 10346 579 579
12670 12670 12330 12330 579 579
14843 14843 14494 14494 579 579
16489 16489 16175 16175 579 579
18317 18317 18041 18041 579 579

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