albums_artists

6 rows where artist_id = 3488

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4879 4879 4653 4653 3488 3488
5193 5193 4949 4949 3488 3488
9721 9721 9375 9375 3488 3488
17161 17161 16859 16859 3488 3488
21114 21114 20980 20980 3488 3488
22566 22566 22472 22472 3488 3488

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