home / pf

reviews_albums

6 rows where review_id = 7149

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
7393 7393 Red Horse, White Mule / Opium Musick / Raag Manifestos / Jack Rose / I Do Play Rock and Roll / Dr. Ragtime and His Pals 7149 7393 7393
7394 7394 Red Horse, White Mule / Opium Musick / Raag Manifestos / Jack Rose / I Do Play Rock and Roll / Dr. Ragtime and His Pals 7149 7394 7394
7395 7395 Red Horse, White Mule / Opium Musick / Raag Manifestos / Jack Rose / I Do Play Rock and Roll / Dr. Ragtime and His Pals 7149 7395 7395
7396 7396 Red Horse, White Mule / Opium Musick / Raag Manifestos / Jack Rose / I Do Play Rock and Roll / Dr. Ragtime and His Pals 7149 7396 7396
7397 7397 Red Horse, White Mule / Opium Musick / Raag Manifestos / Jack Rose / I Do Play Rock and Roll / Dr. Ragtime and His Pals 7149 7397 7397
7398 7398 Red Horse, White Mule / Opium Musick / Raag Manifestos / Jack Rose / I Do Play Rock and Roll / Dr. Ragtime and His Pals 7149 7398 7398

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