home / pf

reviews_authors

32 rows where author_id = 281

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
2805 2805 <em>Quiet Bloom</em> 2805 Ruth Saxelby 281
2831 2831 <em>Thousand Year Stare</em> 2831 Ruth Saxelby 281
2944 2944 <em>Fountain</em> 2944 Ruth Saxelby 281
2995 2995 <em>Conference of Trees</em> 2995 Ruth Saxelby 281
3043 3043 <em>Kulør 006</em> 3043 Ruth Saxelby 281
3127 3127 <em>Desire</em> 3127 Ruth Saxelby 281
3221 3221 Automatic Writing / Improvement (Don Leaves Linda) 3221 Ruth Saxelby 281
3223 3223 <em>Plunge Remix</em> 3223 Ruth Saxelby 281
3263 3263 <em>Catastrophic Deliquescence (Music From Fortitude 2015-2018)</em> 3263 Ruth Saxelby 281
3315 3315 <em>ATØ</em> 3315 Ruth Saxelby 281
3320 3320 <em>Exhaust EP</em> 3320 Ruth Saxelby 281
3388 3388 <em>Sleepmoss</em> 3388 Ruth Saxelby 281
3496 3496 <em>Songs From the Bardo</em> 3496 Ruth Saxelby 281
4214 4214 <em>Walking Wounded</em> 4214 Ruth Saxelby 281
4215 4215 <em>BTTB (20th Anniversary Edition)</em> 4215 Ruth Saxelby 281
4365 4365 <em>Hectic Shakes EP</em> 4365 Ruth Saxelby 281
4561 4561 <em>Siblings</em> 4561 Ruth Saxelby 281
10494 10494 <em>A/B til Infinity</em> 10494 Ruth Saxelby 281
10714 10714 <em>Colonial Patterns</em> 10714 Ruth Saxelby 281
10739 10739 <em>Feast / Beast</em> 10739 Ruth Saxelby 281
11250 11250 <em>Live</em> 11250 Ruth Saxelby 281
11268 11268 <em>The North Borders</em> 11268 Ruth Saxelby 281
11391 11391 <em>Krieg und Frieden (Music for Theatre)</em> 11391 Ruth Saxelby 281
11436 11436 <em>Through the Window</em> 11436 Ruth Saxelby 281
11520 11520 <em>No Thrills</em> 11520 Ruth Saxelby 281
11549 11549 <em>Hardcourage</em> 11549 Ruth Saxelby 281
11728 11728 <em>Lonely at the Top</em> 11728 Ruth Saxelby 281
11835 11835 <em>Tragicomedies</em> 11835 Ruth Saxelby 281
11951 11951 <em>Held</em> 11951 Ruth Saxelby 281
11974 11974 <em>Sebenza</em> 11974 Ruth Saxelby 281
12139 12139 <em>I Make Lists EP</em> 12139 Ruth Saxelby 281
12194 12194 <em>Modeselektion Vol. 02</em> 12194 Ruth Saxelby 281

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