This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15329 | 15329 | ec3ac | 3466 3466 |
| 15330 | 15330 | 21b44 | 3466 3466 |
| 15331 | 15331 | 5e075 | 3466 3466 |
| 15332 | 15332 | 59d75 | 3466 3466 |
| 15333 | 15333 | e6200 | 3466 3466 |
| 15334 | 15334 | 26bad | 3466 3466 |
| 15335 | 15335 | 3fd8f | 3466 3466 |
| 15336 | 15336 | 1bffd | 3466 3466 |
| 15337 | 15337 | b043e | 3466 3466 |
| 15338 | 15338 | 6fd4d | 3466 3466 |
| 15339 | 15339 | 929ee | 3466 3466 |
| 15340 | 15340 | b6530 | 3466 3466 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)