home / pf

reviews_albums

5 rows where review_id = 5599

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
5760 5760 The Wasted Years 5599 5760 5760
5761 5761 The Wasted Years 5599 5761 5761
5762 5762 The Wasted Years 5599 5762 5762
5763 5763 The Wasted Years 5599 5763 5763
5764 5764 The Wasted Years 5599 5764 5764

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.988ms