home / pf

reviews_albums

4 rows where review_id = 7159

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
7408 7408 The ECM Recordings 7159 7408 7408
7409 7409 The ECM Recordings 7159 7409 7409
7410 7410 The ECM Recordings 7159 7410 7410
7411 7411 The ECM Recordings 7159 7411 7411

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