home / pf

albums_artists

10 rows where artist_id = 272

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
279 279 267 267 272 272
1185 1185 1116 1116 272 272
2322 2322 2178 2178 272 272
3700 3700 3500 3500 272 272
5988 5988 5717 5717 272 272
8050 8050 7738 7738 272 272
9423 9423 9075 9075 272 272
9677 9677 9329 9329 272 272
11161 11161 10822 10822 272 272
15669 15669 15331 15331 272 272

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