albums_artists

9 rows where artist_id = 2653

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3369 3369 3178 3178 2653 2653
6918 6918 6619 6619 2653 2653
7680 7680 7374 7374 2653 2653
16835 16835 16526 16526 2653 2653
19681 19681 19482 19482 2653 2653
19682 19682 19483 19483 2653 2653
21055 21055 20914 20914 2653 2653
22467 22467 22371 22371 2653 2653
27464 27464 27289 27289 2653 2653

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