home / pf

reviews_authors

20 rows where author_id = 401

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
6125 6125 <em>Patterns for Resonant Space</em> 6125 Raymond Cummings 401
6213 6213 <em>Psychic Drift</em> 6213 Raymond Cummings 401
6386 6386 <em>Endlings</em> 6386 Raymond Cummings 401
6591 6591 <em>Doris and the Daggers</em> 6591 Raymond Cummings 401
6607 6607 <em>All My Circles Run</em> 6607 Raymond Cummings 401
6653 6653 <em>Buried Wish</em> 6653 Raymond Cummings 401
7014 7014 <em>Ghosthouse</em> 7014 Raymond Cummings 401
7024 7024 <em>Romantic</em> 7024 Raymond Cummings 401
7413 7413 <em>Call by Night</em> 7413 Raymond Cummings 401
7452 7452 <em>Black Bubblegum</em> 7452 Raymond Cummings 401
7507 7507 <em>Jay II</em> 7507 Raymond Cummings 401
7684 7684 <em>As If Apart</em> 7684 Raymond Cummings 401
7966 7966 <em>Mowing</em> 7966 Raymond Cummings 401
8132 8132 <em>Live 1977-1979</em> 8132 Raymond Cummings 401
8262 8262 <em>Accidental Sky</em> 8262 Raymond Cummings 401
8461 8461 <em>Apologues</em> 8461 Raymond Cummings 401
8743 8743 <em>Amusers and Puzzlers</em> 8743 Raymond Cummings 401
8793 8793 <em>UFO Rot</em> 8793 Raymond Cummings 401
8934 8934 <em>Batu Malablab: Suite for Prepared Piano, Flute and Electronics</em> 8934 Raymond Cummings 401
9011 9011 <em>Era of Manifestations</em> 9011 Raymond Cummings 401

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE reviews_authors (
	review_id integer NOT NULL,
	author_id integer NOT NULL,
	FOREIGN KEY(review_id) REFERENCES reviews(id),
	FOREIGN KEY(author_id) REFERENCES authors(id),
	UNIQUE(review_id,author_id)
);
Powered by Datasette · Queries took 56.112ms