reviews_authors
3 rows where author_id = 255
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | author_id |
|---|---|---|---|
| 2156 | 2156 | <em>Sin Miedo (del Amor y Otros Demonios) ∞</em> 2156 | Jenzia Burgos 255 |
| 2499 | 2499 | <em>Everlasting</em> 2499 | Jenzia Burgos 255 |
| 2938 | 2938 | <em>Colores</em> 2938 | Jenzia Burgos 255 |
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) );