home / pf

reviews_albums

3 rows where review_id = 4399

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
4500 4500 Some Kind of Cadwallader 4399 4500 4500
4501 4501 Some Kind of Cadwallader 4399 4501 4501
4502 4502 Some Kind of Cadwallader 4399 4502 4502

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