home / pf

albums_artists

6 rows where artist_id = 137

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
142 142 137 137 137 137
12899 12899 12556 12556 137 137
12900 12900 12557 12557 137 137
13517 13517 13166 13166 137 137
14200 14200 13840 13840 137 137
25996 25996 25896 25896 137 137

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