albums_artists

7 rows where artist_id = 652

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
674 674 646 646 652 652
4439 4439 4225 4225 652 652
7178 7178 6879 6879 652 652
7422 7422 7121 7121 652 652
8195 8195 7875 7875 652 652
11274 11274 10938 10938 652 652
12273 12273 11936 11936 652 652

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