This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18409 | 18409 | cc5ed | 2029 2029 |
| 18410 | 18410 | 371f0 | 2029 2029 |
| 18411 | 18411 | e6200 | 2029 2029 |
| 18412 | 18412 | b1201 | 2029 2029 |
| 18413 | 18413 | 8a7ee | 2029 2029 |
| 18414 | 18414 | 862ed | 2029 2029 |
| 18415 | 18415 | a1307 | 2029 2029 |
| 18416 | 18416 | abb72 | 2029 2029 |
| 18417 | 18417 | 27369 | 2029 2029 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)