albums_artists

6 rows where artist_id = 1567

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1755 1755 1656 1656 1567 1567
2851 2851 2684 2684 1567 1567
2852 2852 2685 2685 1567 1567
3657 3657 3461 3461 1567 1567
4548 4548 4332 4332 1567 1567
5546 5546 5289 5289 1567 1567

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