reviews_albums
6 rows where review_id = 10371
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | album_id |
|---|---|---|---|
| 10827 | 10827 | Tuck Box 10371 | 10827 10827 |
| 10828 | 10828 | Tuck Box 10371 | 10828 10828 |
| 10829 | 10829 | Tuck Box 10371 | 10829 10829 |
| 10830 | 10830 | Tuck Box 10371 | 10830 10830 |
| 10831 | 10831 | Tuck Box 10371 | 10831 10831 |
| 10832 | 10832 | Tuck Box 10371 | 10832 10832 |
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) );