home / pf

reviews_albums

5 rows where review_id = 3047

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
3117 3117 The Rising / Devils & Dust / Live in New York City / Live in Dublin / 18 Tracks 3047 3117 3117
3118 3118 The Rising / Devils & Dust / Live in New York City / Live in Dublin / 18 Tracks 3047 3118 3118
3119 3119 The Rising / Devils & Dust / Live in New York City / Live in Dublin / 18 Tracks 3047 3119 3119
3120 3120 The Rising / Devils & Dust / Live in New York City / Live in Dublin / 18 Tracks 3047 3120 3120
3121 3121 The Rising / Devils & Dust / Live in New York City / Live in Dublin / 18 Tracks 3047 3121 3121

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