home / pf

reviews_albums

3 rows where review_id = 8544

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
8910 8910 All In One Peace 8544 8910 8910
8911 8911 All In One Peace 8544 8911 8911
8912 8912 All In One Peace 8544 8912 8912

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