reviews_albums
7 rows where review_id = 3258
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | album_id |
|---|---|---|---|
| 3334 | 3334 | We Are Beat Happening 3258 | 3334 3334 |
| 3335 | 3335 | We Are Beat Happening 3258 | 3335 3335 |
| 3336 | 3336 | We Are Beat Happening 3258 | 3336 3336 |
| 3337 | 3337 | We Are Beat Happening 3258 | 3337 3337 |
| 3338 | 3338 | We Are Beat Happening 3258 | 3338 3338 |
| 3339 | 3339 | We Are Beat Happening 3258 | 3339 3339 |
| 3340 | 3340 | We Are Beat Happening 3258 | 3340 3340 |
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) );