albums_artists

7 rows where artist_id = 263

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
270 270 258 258 263 263
8202 8202 7882 7882 263 263
12734 12734 12395 12395 263 263
17012 17012 16706 16706 263 263
20815 20815 20660 20660 263 263
23375 23375 23273 23273 263 263
24786 24786 24670 24670 263 263

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