reviews_authors
10 rows where author_id = 263
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 2362 | 2362 | <em>&&&&&</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
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) );