home / pf

albums_artists

15 rows where artist_id = 2981

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3952 3952 3750 3750 2981 2981
4742 4742 4526 4526 2981 2981
7574 7574 7268 7268 2981 2981
7576 7576 7269 7269 2981 2981
8497 8497 8166 8166 2981 2981
9109 9109 8769 8769 2981 2981
10045 10045 9701 9701 2981 2981
19180 19180 18959 18959 2981 2981
20966 20966 20820 20820 2981 2981
21459 21459 21339 21339 2981 2981
23645 23645 23541 23541 2981 2981
23646 23646 23542 23542 2981 2981
23983 23983 23871 23871 2981 2981
24292 24292 24182 24182 2981 2981
24636 24636 24514 24514 2981 2981

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