home / pf

reviews_authors

18 rows where author_id = 94

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
182 182 <em>Nicks and Grazes</em>  182 Rob Arcand 94
377 377 <em>Eccentric Soul: The Shiptown Label</em> 377 Rob Arcand 94
525 525 <em>Natural Part</em> 525 Rob Arcand 94
757 757 <em>Moten/López/Cleaver</em> 757 Rob Arcand 94
884 884 <em>Hunter on the Wing</em> 884 Rob Arcand 94
1375 1375 <em>Backwards and Forwards (The WEA Recordings 1984-1995)</em> 1375 Rob Arcand 94
1748 1748 <em>Hanazono</em> 1748 Rob Arcand 94
1782 1782 <em>a softer focus</em> 1782 Rob Arcand 94
2015 2015 <em>Music for Parents</em> 2015 Rob Arcand 94
2054 2054 <em>Somewhere Between: Mutant Pop, Electronic Minimalism &amp; Shadow Sounds of Japan 1980-1988</em> 2054 Rob Arcand 94
2344 2344 <em>Finds You Well</em> 2344 Rob Arcand 94
2426 2426 <em>Knot</em> 2426 Rob Arcand 94
2920 2920 <em>Snapshot of a Beginner</em> 2920 Rob Arcand 94
25286 25286 <em>12</em> 25282 Rob Arcand 94
25431 25431 <em>A View of a Landscape</em> 25427 Rob Arcand 94
25746 25746 <em>The Happiest Times I Ever Ignored</em> 25742 Rob Arcand 94
25796 25796 <em>Pure Music</em> 25792 Rob Arcand 94
26113 26113 <em>512</em> 26109 Rob Arcand 94

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