home / pf

reviews_albums

7 rows where review_id = 5130

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
5274 5274 The Album Collection Vol. 2, 1987-1996 5130 5274 5274
5275 5275 The Album Collection Vol. 2, 1987-1996 5130 5275 5275
5276 5276 The Album Collection Vol. 2, 1987-1996 5130 5276 5276
5277 5277 The Album Collection Vol. 2, 1987-1996 5130 5277 5277
5278 5278 The Album Collection Vol. 2, 1987-1996 5130 5278 5278
5279 5279 The Album Collection Vol. 2, 1987-1996 5130 5279 5279
5280 5280 The Album Collection Vol. 2, 1987-1996 5130 5280 5280

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