albums_artists

6 rows where artist_id = 6618

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12041 12041 11700 11700 6618 6618
17067 17067 16764 16764 6618 6618
22773 22773 22683 22683 6618 6618
25021 25021 24914 24914 6618 6618
26157 26157 26055 26055 6618 6618
26158 26158 26056 26056 6618 6618

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