home / pf

reviews_authors

32 rows where author_id = 129

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
320 320 <em>Pulse of the Early Brain (Switched On, Vol. 5)</em> 320 Robert Ham 129
871 871 <em>Keep On With Falling</em> 871 Robert Ham 129
1751 1751 <em>This Is Telex</em> 1751 Robert Ham 129
1920 1920 <em>Quiet Life</em> 1920 Robert Ham 129
1948 1948 <em>Electrically Possessed (Switched On Vol. 4)</em> 1948 Robert Ham 129
2026 2026 <em>The Third Chimpanzee EP</em> 2026 Robert Ham 129
2067 2067 <em>Complete UA Singles 1977-1980</em> 2067 Robert Ham 129
2151 2151 <em>Shadow of Fear</em> 2151 Robert Ham 129
2338 2338 <em>ACR Loco</em> 2338 Robert Ham 129
2457 2457 <em>The Neon</em> 2457 Robert Ham 129
2468 2468 <em>Luminous</em> 2468 Robert Ham 129
2619 2619 Red Cross EP / Phaseshifter / Show World 2619 Robert Ham 129
3058 3058 <em>Molocular Meditation</em> 3058 Robert Ham 129
3149 3149 <em>The Comforts of Madness</em> 3149 Robert Ham 129
3421 3421 <em>Use Hearing Protection: Factory Records 1978-79</em> 3421 Robert Ham 129
4766 4766 <em>Rainier Fog</em> 4766 Robert Ham 129
4875 4875 Repeat/Metal/Made Available/Live 80-81 4875 Robert Ham 129
4962 4962 <em>Plight &amp; Premonition / Flux &amp; Mutability</em> 4962 Robert Ham 129
5061 5061 <em>Listening to Pictures (Pentimento Volume One)</em> 5061 Robert Ham 129
5235 5235 <em>Inter-Fusion</em> 5235 Robert Ham 129
5503 5503 <em>Early Tape Works (1986-1993) Vol.1</em> 5503 Robert Ham 129
5599 5599 The Wasted Years 5599 Robert Ham 129
5633 5633 <em>Finding Shore</em> 5633 Robert Ham 129
5721 5721 <em>Wasps’ Nests</em> 5721 Robert Ham 129
5746 5746 <em>U-Men</em> 5746 Robert Ham 129
6126 6126 <em>New Facts Emerge</em> 6126 Robert Ham 129
6309 6309 <em>Different Days</em> 6309 Robert Ham 129
6586 6586 <em>Find Me Finding You</em> 6586 Robert Ham 129
6769 6769 <em>Dog</em> 6769 Robert Ham 129
6853 6853 <em>Cockfighters EP</em> 6853 Robert Ham 129
7812 7812 <em>Eric Bachmann</em> 7812 Robert Ham 129
8071 8071 <em>Here Come the Rattling Trees</em> 8071 Robert Ham 129

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