home / pf

reviews_albums

6 rows where review_id = 10371

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
10827 10827 Tuck Box 10371 10827 10827
10828 10828 Tuck Box 10371 10828 10828
10829 10829 Tuck Box 10371 10829 10829
10830 10830 Tuck Box 10371 10830 10830
10831 10831 Tuck Box 10371 10831 10831
10832 10832 Tuck Box 10371 10832 10832

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