home / pf

reviews_albums

7 rows where review_id = 5339

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
5493 5493 The Asylum Era 5339 5493 5493
5494 5494 The Asylum Era 5339 5494 5494
5495 5495 The Asylum Era 5339 5495 5495
5496 5496 The Asylum Era 5339 5496 5496
5497 5497 The Asylum Era 5339 5497 5497
5498 5498 The Asylum Era 5339 5498 5498
5499 5499 The Asylum Era 5339 5499 5499

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