albums_artists

7 rows where artist_id = 3304

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4522 4522 4305 4305 3304 3304
6793 6793 6495 6495 3304 3304
11867 11867 11525 11525 3304 3304
12704 12704 12365 12365 3304 3304
13854 13854 13497 13497 3304 3304
24611 24611 24489 24489 3304 3304
25972 25972 25874 25874 3304 3304

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