albums_artists

10 rows where artist_id = 4749

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7685 7685 7379 7379 4749 4749
10290 10290 9949 9949 4749 4749
10714 10714 10379 10379 4749 4749
15526 15526 15185 15185 4749 4749
17562 17562 17266 17266 4749 4749
19804 19804 19609 19609 4749 4749
21651 21651 21538 21538 4749 4749
24852 24852 24737 24737 4749 4749
25863 25863 25765 25765 4749 4749
27295 27295 27128 27128 4749 4749

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