reviews_authors
17 rows where author_id = 406
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 6315 | 6315 | <em>Supreme Clientele</em> 6315 | Jeff Weiss 406 |
| 7357 | 7357 | <em>Dangerous</em> 7357 | Jeff Weiss 406 |
| 7712 | 7712 | <em>Diamonds and Pearls</em> 7712 | Jeff Weiss 406 |
| 9357 | 9357 | <em>Pom Pom</em> 9357 | Jeff Weiss 406 |
| 11187 | 11187 | <em>Acid Rap</em> 11187 | Jeff Weiss 406 |
| 11557 | 11557 | <em>Illmatic</em> 11557 | Jeff Weiss 406 |
| 11801 | 11801 | <em>Cobra Juicy</em> 11801 | Jeff Weiss 406 |
| 12157 | 12157 | <em>Skelethon</em> 12157 | Jeff Weiss 406 |
| 12322 | 12322 | <em>Cancer for Cure</em> 12322 | Jeff Weiss 406 |
| 12515 | 12515 | <em>Kenny Dennis EP</em> 12515 | Jeff Weiss 406 |
| 12527 | 12527 | <em>Blue Chips</em> 12527 | Jeff Weiss 406 |
| 12680 | 12680 | <em>Subject: Matter</em> 12680 | Jeff Weiss 406 |
| 12799 | 12799 | <em>Jet World Order</em> 12799 | Jeff Weiss 406 |
| 12826 | 12826 | <em>Emika</em> 12826 | Jeff Weiss 406 |
| 12900 | 12900 | <em>The 9th Inning EP</em> 12900 | Jeff Weiss 406 |
| 12917 | 12917 | <em>LIVELOVEA$AP</em> 12917 | Jeff Weiss 406 |
| 12924 | 12924 | <em>For the Glory</em> 12924 | Jeff Weiss 406 |
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) );