home / pf

reviews_authors

10 rows where author_id = 263

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
2362 2362 <em>&amp;&amp;&amp;&amp;&amp;</em> 2362 Emilie Friedlander 263
2646 2646 <em>Homegrown</em> 2646 Emilie Friedlander 263
12114 12114 <em>Jared's Lot</em> 12114 Emilie Friedlander 263
12439 12439 <em>History</em> 12439 Emilie Friedlander 263
12493 12493 <em>Milo Goes to Compton</em> 12493 Emilie Friedlander 263
12578 12578 <em>Dispossession</em> 12578 Emilie Friedlander 263
12673 12673 <em>And They Turned Not When They Went</em> 12673 Emilie Friedlander 263
12743 12743 <em>Hubble Drums</em> 12743 Emilie Friedlander 263
12838 12838 <em>Quilt</em> 12838 Emilie Friedlander 263
12878 12878 <em>Youth II EP</em> 12878 Emilie Friedlander 263

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