albums_artists

9 rows where artist_id = 7509

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
14503 14503 14147 14147 7509 7509
16389 16389 16076 16076 7509 7509
16654 16654 16344 16344 7509 7509
16986 16986 16678 16678 7509 7509
17199 17199 16895 16895 7509 7509
19140 19140 18916 18916 7509 7509
21081 21081 20944 20944 7509 7509
22805 22805 22714 22714 7509 7509
22991 22991 22894 22894 7509 7509

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