reviews_albums

3 rows where review_id = 20876

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
21820 21820 Snowball + Singles / Skywriting + Singles / For Keeps + Singles 20876 21817 21817
21821 21821 Snowball + Singles / Skywriting + Singles / For Keeps + Singles 20876 21818 21818
21822 21822 Snowball + Singles / Skywriting + Singles / For Keeps + Singles 20876 21819 21819

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)
);