home / pf

albums_artists

8 rows where artist_id = 4906

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8072 8072 7759 7759 4906 4906
8885 8885 8551 8551 4906 4906
11368 11368 11029 11029 4906 4906
12122 12122 11783 11783 4906 4906
12534 12534 12195 12195 4906 4906
13872 13872 13515 13515 4906 4906
14243 14243 13883 13883 4906 4906
14244 14244 13884 13884 4906 4906

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 43.549ms