albums_artists

10 rows where artist_id = 344

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
351 351 335 335 344 344
1996 1996 1880 1880 344 344
3737 3737 3538 3538 344 344
4765 4765 4548 4548 344 344
6707 6707 6416 6416 344 344
11441 11441 11102 11102 344 344
11902 11902 11559 11559 344 344
13997 13997 13642 13642 344 344
14889 14889 14541 14541 344 344
26750 26750 26619 26619 344 344

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