home / pf

reviews_authors

53 rows where author_id = 516

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
14010 14010 <em>Prism Eyes</em> 14010 Amy Granzin 516
14256 14256 <em>Fields</em> 14256 Amy Granzin 516
14288 14288 <em>This Alone Above All Else in Spite of Everything</em> 14288 Amy Granzin 516
14354 14354 <em>House of Tongues</em> 14354 Amy Granzin 516
14455 14455 <em>Made the Harbor</em> 14455 Amy Granzin 516
14476 14476 <em>Disconnect From Desire</em> 14476 Amy Granzin 516
14513 14513 <em>Listen for the Clues</em> 14513 Amy Granzin 516
14538 14538 <em>All Creatures Will Make Merry</em> 14538 Amy Granzin 516
14615 14615 <em>Callin' All</em> 14615 Amy Granzin 516
14719 14719 Instant Coffee Baby / If You Leave It Alone 14719 Amy Granzin 516
14879 14879 <em>Rough Frame EP</em> 14879 Amy Granzin 516
14944 14944 <em>Coconut</em> 14944 Amy Granzin 516
14977 14977 <em>Hidden</em> 14977 Amy Granzin 516
15024 15024 <em>Heart of My Own</em> 15024 Amy Granzin 516
15063 15063 <em>YellowFever</em> 15063 Amy Granzin 516
15141 15141 <em>Who Designs Nature's How</em> 15141 Amy Granzin 516
15308 15308 <em>Summer of Fear</em> 15308 Amy Granzin 516
15398 15398 <em>Threadbare</em> 15398 Amy Granzin 516
15472 15472 <em>The Stone Roses</em> 15472 Amy Granzin 516
15571 15571 <em>Speech Therapy</em> 15571 Amy Granzin 516
15582 15582 <em>Infinite Light</em> 15582 Amy Granzin 516
15619 15619 <em>Eugene McGuinness</em> 15619 Amy Granzin 516
15690 15690 <em>The Guilty Office</em> 15690 Amy Granzin 516
15770 15770 <em>My Electric Family</em> 15770 Amy Granzin 516
15844 15844 <em>Death Control</em> 15844 Amy Granzin 516
15897 15897 <em>Enter the Vaselines</em> 15897 Amy Granzin 516
15941 15941 <em>Winter Hours</em> 15941 Amy Granzin 516
15950 15950 <em>You Can Have What You Want</em> 15950 Amy Granzin 516
16044 16044 <em>Elvis Perkins in Dearland</em> 16044 Amy Granzin 516
16137 16137 <em>To Be Still</em> 16137 Amy Granzin 516
16160 16160 <em>Davy</em> 16160 Amy Granzin 516
16219 16219 <em>Parplar</em> 16219 Amy Granzin 516
16265 16265 <em>How Shadows Chase the Balance</em> 16265 Amy Granzin 516
16390 16390 <em>(k)no(w)here</em> 16390 Amy Granzin 516
16457 16457 <em>Live: Hope at the Hideout</em> 16457 Amy Granzin 516
16462 16462 <em>Alight of Night</em> 16462 Amy Granzin 516
16500 16500 <em>Temper</em> 16500 Amy Granzin 516
16537 16537 <em>Forfeit/Fortune</em> 16537 Amy Granzin 516
16563 16563 <em>Vivian Girls</em> 16563 Amy Granzin 516
16631 16631 <em>Lunglight</em> 16631 Amy Granzin 516
16670 16670 <em>The Lord Dog Bird</em> 16670 Amy Granzin 516
16730 16730 <em>Carefree</em> 16730 Amy Granzin 516
16775 16775 <em>Nukkuu</em> 16775 Amy Granzin 516
16860 16860 <em>Fear of Flying</em> 16860 Amy Granzin 516
16863 16863 <em>Bubble and Scrape Deluxe Edition</em> 16863 Amy Granzin 516
16946 16946 <em>After Hours</em> 16946 Amy Granzin 516
16972 16972 <em>Thing of the Past</em> 16972 Amy Granzin 516
17025 17025 <em>Autumn Fallin'</em> 17025 Amy Granzin 516
17075 17075 <em>Brutal</em> 17075 Amy Granzin 516
17086 17086 <em>Yeti #5</em> 17086 Amy Granzin 516
17187 17187 <em>Little Death</em> 17187 Amy Granzin 516
17292 17292 <em>Transparent Knives</em> 17292 Amy Granzin 516
17327 17327 <em>David Thomas Broughton vs. 7 Hertz</em> 17327 Amy Granzin 516

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