This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 470 | 470 | cc5ed | 3021 3021 |
| 471 | 471 | d6ade | 3021 3021 |
| 472 | 472 | 8e7b3 | 3021 3021 |
| 473 | 473 | 2dfbd | 3021 3021 |
| 474 | 474 | 4e7f1 | 3021 3021 |
| 475 | 475 | 591c8 | 3021 3021 |
| 476 | 476 | 3bf90 | 3021 3021 |
| 477 | 477 | 371f0 | 3021 3021 |
| 478 | 478 | e6200 | 3021 3021 |
| 479 | 479 | b1201 | 3021 3021 |
| 480 | 480 | 04629 | 3021 3021 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)