reviews_albums
5 rows where review_id = 7058
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | album_id |
|---|---|---|---|
| 7298 | 7298 | R M H Q: Headquarters 7058 | 7298 7298 |
| 7299 | 7299 | R M H Q: Headquarters 7058 | 7299 7299 |
| 7300 | 7300 | R M H Q: Headquarters 7058 | 7300 7300 |
| 7301 | 7301 | R M H Q: Headquarters 7058 | 7301 7301 |
| 7302 | 7302 | R M H Q: Headquarters 7058 | 7302 7302 |
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) );