reviews_albums
6 rows where review_id = 8138
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | album_id |
|---|---|---|---|
| 8460 | 8460 | Complete Works 8138 | 8460 8460 |
| 8461 | 8461 | Complete Works 8138 | 8461 8461 |
| 8462 | 8462 | Complete Works 8138 | 8462 8462 |
| 8463 | 8463 | Complete Works 8138 | 8463 8463 |
| 8464 | 8464 | Complete Works 8138 | 8464 8464 |
| 8465 | 8465 | Complete Works 8138 | 8465 8465 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE reviews_albums ( review_id integer NOT NULL, album_id integer NOT NULL, FOREIGN KEY(review_id) REFERENCES reviews(id), FOREIGN KEY(album_id) REFERENCES albums(id), UNIQUE(review_id, album_id) );