This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10518 | 10518 | ec3ac | 1359 1359 |
| 10519 | 10519 | ea4d7 | 1359 1359 |
| 10520 | 10520 | 685a3 | 1359 1359 |
| 10521 | 10521 | 5e075 | 1359 1359 |
| 10522 | 10522 | 59d75 | 1359 1359 |
| 10523 | 10523 | e6200 | 1359 1359 |
| 10524 | 10524 | b1201 | 1359 1359 |
| 10525 | 10525 | 40a6c | 1359 1359 |
| 10526 | 10526 | f03e5 | 1359 1359 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)