reviews_authors
15 rows where author_id = 503
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 12556 | 12556 | <em>Closer EP</em> 12556 | Brandon Soderberg 503 |
| 12628 | 12628 | <em>808 Mafia</em> 12628 | Brandon Soderberg 503 |
| 12775 | 12775 | <em>Inhale C-4 $$$$$</em> 12775 | Brandon Soderberg 503 |
| 12881 | 12881 | <em>iSLAND</em> 12881 | Brandon Soderberg 503 |
| 12934 | 12934 | <em>Far Side Virtual</em> 12934 | Brandon Soderberg 503 |
| 13011 | 13011 | <em>One Pig</em> 13011 | Brandon Soderberg 503 |
| 13187 | 13187 | <em>Thursday</em> 13187 | Brandon Soderberg 503 |
| 13276 | 13276 | <em>Timesup EP</em> 13276 | Brandon Soderberg 503 |
| 13317 | 13317 | <em>Within and Without</em> 13317 | Brandon Soderberg 503 |
| 13371 | 13371 | <em>Digital Lows</em> 13371 | Brandon Soderberg 503 |
| 13443 | 13443 | <em>Blvcklvnd Rvdix 66.6 (1991)</em> 13443 | Brandon Soderberg 503 |
| 13579 | 13579 | <em>Gatto Fritto</em> 13579 | Brandon Soderberg 503 |
| 13635 | 13635 | <em>Instrumental Mixtape</em> 13635 | Brandon Soderberg 503 |
| 13843 | 13843 | <em>Divine EP</em> 13843 | Brandon Soderberg 503 |
| 13937 | 13937 | <em>The ONE... COHESIVE</em> 13937 | Brandon Soderberg 503 |
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) );