This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18536 | 18536 | cc5ed | 2070 2070 |
| 18537 | 18537 | 7b150 | 2070 2070 |
| 18538 | 18538 | e6200 | 2070 2070 |
| 18539 | 18539 | b1201 | 2070 2070 |
| 18540 | 18540 | 8a7ee | 2070 2070 |
| 18541 | 18541 | 862ed | 2070 2070 |
| 18542 | 18542 | 91693 | 2070 2070 |
| 18543 | 18543 | 487f2 | 2070 2070 |
| 18544 | 18544 | abb72 | 2070 2070 |
| 18545 | 18545 | 27369 | 2070 2070 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)