home / pf

reviews_albums

6 rows where review_id = 8138

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
8460 8460 Complete Works 8138 8460 8460
8461 8461 Complete Works 8138 8461 8461
8462 8462 Complete Works 8138 8462 8462
8463 8463 Complete Works 8138 8463 8463
8464 8464 Complete Works 8138 8464 8464
8465 8465 Complete Works 8138 8465 8465

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE reviews_albums (
	review_id integer NOT NULL,
	album_id integer NOT NULL,
	FOREIGN KEY(review_id) REFERENCES reviews(id),
	FOREIGN KEY(album_id) REFERENCES albums(id),
	UNIQUE(review_id, album_id)
);
Powered by Datasette · Queries took 9.499ms