home / pf

albums_artists

11 rows where artist_id = 3324

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4555 4555 4339 4339 3324 3324
4556 4556 4340 4340 3324 3324
4557 4557 4341 4341 3324 3324
4558 4558 4342 4342 3324 3324
5355 5355 5104 5104 3324 3324
13521 13521 13170 13170 3324 3324
15095 15095 14750 14750 3324 3324
16401 16401 16087 16087 3324 3324
24879 24879 24767 24767 3324 3324
25866 25866 25768 25768 3324 3324
26364 26364 26258 26258 3324 3324

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