albums_artists

6 rows where artist_id = 2492

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3110 3110 2932 2932 2492 2492
4446 4446 4232 4232 2492 2492
6556 6556 6267 6267 2492 2492
13109 13109 12771 12771 2492 2492
21201 21201 21075 21075 2492 2492
21202 21202 21076 21076 2492 2492

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