home / pf

reviews_albums

6 rows where review_id = 3289

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
3371 3371 The Legendary Riverside Albums 3289 3371 3371
3372 3372 The Legendary Riverside Albums 3289 3372 3372
3373 3373 The Legendary Riverside Albums 3289 3373 3373
3374 3374 The Legendary Riverside Albums 3289 3374 3374
3375 3375 The Legendary Riverside Albums 3289 3375 3375
3376 3376 The Legendary Riverside Albums 3289 3376 3376

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