home / pf

albums_artists

8 rows where artist_id = 7960

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15860 15860 15516 15516 7960 7960
18736 18736 18493 18493 7960 7960
19221 19221 19001 19001 7960 7960
19965 19965 19777 19777 7960 7960
21361 21361 21238 21238 7960 7960
22317 22317 22228 22228 7960 7960
22956 22956 22860 22860 7960 7960
24086 24086 23976 23976 7960 7960

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