This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34872 | 34872 | 3fe3b | 299 299 |
| 34873 | 34873 | 74353 | 299 299 |
| 34874 | 34874 | 27176 | 299 299 |
| 34875 | 34875 | ebe26 | 299 299 |
| 34876 | 34876 | 371f0 | 299 299 |
| 34877 | 34877 | e6200 | 299 299 |
| 34878 | 34878 | b1201 | 299 299 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)