This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16455 | 16455 | cc5ed | 3000 3000 |
| 16456 | 16456 | 371f0 | 3000 3000 |
| 16457 | 16457 | e6200 | 3000 3000 |
| 16458 | 16458 | b1201 | 3000 3000 |
| 16459 | 16459 | 8a7ee | 3000 3000 |
| 16460 | 16460 | 862ed | 3000 3000 |
| 16461 | 16461 | 4d5c2 | 3000 3000 |
| 16462 | 16462 | 225c8 | 3000 3000 |
| 16463 | 16463 | 466b8 | 3000 3000 |
| 16464 | 16464 | 91181 | 3000 3000 |
| 16465 | 16465 | d723b | 3000 3000 |
| 16466 | 16466 | 87070 | 3000 3000 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)