home / pf

albums_artists

6 rows where artist_id = 4163

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6361 6361 6072 6072 4163 4163
8742 8742 8409 8409 4163 4163
9029 9029 8689 8689 4163 4163
11425 11425 11086 11086 4163 4163
26514 26514 26403 26403 4163 4163
27525 27525 27340 27340 4163 4163

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)
);
Powered by Datasette · Queries took 59.737ms