albums_artists

14 rows where artist_id = 548

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
564 564 540 540 548 548
4121 4121 3921 3921 548 548
6544 6544 6255 6255 548 548
6545 6545 6256 6256 548 548
6546 6546 6257 6257 548 548
6547 6547 6258 6258 548 548
9779 9779 9431 9431 548 548
13427 13427 13077 13077 548 548
16333 16333 16019 16019 548 548
18148 18148 17864 17864 548 548
19565 19565 19353 19353 548 548
20279 20279 20104 20104 548 548
21063 21063 20924 20924 548 548
26600 26600 26485 26485 548 548

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