reviews_authors
10 rows where author_id = 462
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 8364 | 8364 | <em>Age of Transparency</em> 8364 | Puja Patel 462 |
| 10664 | 10664 | <em>Lost</em> 10664 | Puja Patel 462 |
| 10913 | 10913 | <em>High Beams EP</em> 10913 | Puja Patel 462 |
| 10980 | 10980 | <em>Without Your Love</em> 10980 | Puja Patel 462 |
| 10995 | 10995 | <em>Planta</em> 10995 | Puja Patel 462 |
| 11058 | 11058 | <em>Chapter II</em> 11058 | Puja Patel 462 |
| 11090 | 11090 | <em>Modern Worship</em> 11090 | Puja Patel 462 |
| 11319 | 11319 | <em>The Empire Never Ended</em> 11319 | Puja Patel 462 |
| 11521 | 11521 | <em>0181</em> 11521 | Puja Patel 462 |
| 11553 | 11553 | <em>Fabriclive 67</em> 11553 | Puja Patel 462 |
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) );