home / pf

reviews_authors

34 rows where author_id = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
9 9 <em>Solos</em> 9 Jonathan Williger 7
517 517 <em>Image Langage</em> 517 Jonathan Williger 7
576 576 <em>Editrix II: Editrix Goes to Hell</em> 576 Jonathan Williger 7
694 694 <em>Murmurations // Winds Bells Falls</em> 694 Jonathan Williger 7
924 924 <em>Plonk</em> 924 Jonathan Williger 7
942 942 <em>Bobby Weir &amp; Wolf Bros: Live in Colorado</em> 942 Jonathan Williger 7
1085 1085 <em>The Time of Foxgloves</em> 1085 Jonathan Williger 7
1122 1122 <em>Body/Dilloway/Head</em> 1122 Jonathan Williger 7
1219 1219 <em>Lull</em> 1219 Jonathan Williger 7
1425 1425 <em>A Hole in the Fence</em> 1425 Jonathan Williger 7
1543 1543 <em>Yasuragi Land</em> 1543 Jonathan Williger 7
1705 1705 <em>Mirror Guide</em> 1705 Jonathan Williger 7
1842 1842 <em>Fantas Variations</em> 1842 Jonathan Williger 7
2086 2086 <em>it was always worth it</em> 2086 Jonathan Williger 7
2183 2183 <em>Stolen Car</em> 2183 Jonathan Williger 7
2273 2273 <em>TOCSIN</em> 2273 Jonathan Williger 7
2345 2345 <em>The Reinvention of Romance</em> 2345 Jonathan Williger 7
2382 2382 <em>No era sólida</em> 2382 Jonathan Williger 7
2487 2487 <em>Harbors</em> 2487 Jonathan Williger 7
2561 2561 <em>Species</em> 2561 Jonathan Williger 7
2633 2633 <em>The Shadows and the Light</em> 2633 Jonathan Williger 7
2785 2785 <em>Yeo​-​Neun</em> 2785 Jonathan Williger 7
2828 2828 <em>Selbstportrait Wahre Liebe</em> 2828 Jonathan Williger 7
2949 2949 <em>Lapse in Passage</em> 2949 Jonathan Williger 7
3005 3005 <em>Flood Dream</em> 3005 Jonathan Williger 7
3091 3091 <em>Deep Listening</em> 3091 Jonathan Williger 7
3449 3449 <em>Odds Against Tomorrow</em> 3449 Jonathan Williger 7
3634 3634 <em>Equivalents</em> 3634 Jonathan Williger 7
3865 3865 <em>Spiritual 2</em> 3865 Jonathan Williger 7
4500 4500 <em>Towards the Shadow</em> 4500 Jonathan Williger 7
25307 25307 <em>Does Spring Hide Its Joy</em> 25303 Jonathan Williger 7
25551 25551 <em>Since Time Is Gravity</em> 25547 Jonathan Williger 7
26005 26005 <em>Perspective EP</em> 26001 Jonathan Williger 7
26152 26152 <em>Music Is Victory Over Time</em> 26148 Jonathan Williger 7

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