home / pf

reviews_albums

7 rows where review_id = 3258

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
3334 3334 We Are Beat Happening 3258 3334 3334
3335 3335 We Are Beat Happening 3258 3335 3335
3336 3336 We Are Beat Happening 3258 3336 3336
3337 3337 We Are Beat Happening 3258 3337 3337
3338 3338 We Are Beat Happening 3258 3338 3338
3339 3339 We Are Beat Happening 3258 3339 3339
3340 3340 We Are Beat Happening 3258 3340 3340

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