albums_artists

5 rows where artist_id = 7871

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15609 15609 15271 15271 7871 7871
19501 19501 19287 19287 7871 7871
21379 21379 21257 21257 7871 7871
21747 21747 21639 21639 7871 7871
22844 22844 22749 22749 7871 7871

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