albums_artists

10 rows where artist_id = 2407

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2978 2978 2807 2807 2407 2407
7153 7153 6853 6853 2407 2407
8643 8643 8309 8309 2407 2407
15092 15092 14747 14747 2407 2407
15847 15847 15504 15504 2407 2407
15848 15848 15505 15505 2407 2407
19301 19301 19083 19083 2407 2407
22377 22377 22286 22286 2407 2407
26103 26103 25999 25999 2407 2407
27010 27010 26860 26860 2407 2407

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