albums_artists

5 rows where artist_id = 4563

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7242 7242 6945 6945 4563 4563
9565 9565 9219 9219 4563 4563
11879 11879 11537 11537 4563 4563
13920 13920 13562 13562 4563 4563
16071 16071 15744 15744 4563 4563

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