albums_artists

6 rows where artist_id = 1427

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1576 1576 1487 1487 1427 1427
1997 1997 1881 1881 1427 1427
2367 2367 2220 2220 1427 1427
3119 3119 2941 2941 1427 1427
5157 5157 4914 4914 1427 1427
26685 26685 26560 26560 1427 1427

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