home / pf

reviews_albums

7 rows where review_id = 2700

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
2761 2761 The Bowie Years 2700 2761 2761
2762 2762 The Bowie Years 2700 2762 2762
2763 2763 The Bowie Years 2700 2763 2763
2764 2764 The Bowie Years 2700 2764 2764
2765 2765 The Bowie Years 2700 2765 2765
2766 2766 The Bowie Years 2700 2766 2766
2767 2767 The Bowie Years 2700 2767 2767

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