This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28544 | 28544 | cc5ed | 3199 3199 |
| 28545 | 28545 | d6ade | 3199 3199 |
| 28546 | 28546 | 8e7b3 | 3199 3199 |
| 28547 | 28547 | d1b15 | 3199 3199 |
| 28548 | 28548 | 5ad28 | 3199 3199 |
| 28549 | 28549 | c1ffd | 3199 3199 |
| 28550 | 28550 | 2dfbd | 3199 3199 |
| 28551 | 28551 | 4e7f1 | 3199 3199 |
| 28552 | 28552 | fbbdb | 3199 3199 |
| 28553 | 28553 | a0f55 | 3199 3199 |
| 28554 | 28554 | 371f0 | 3199 3199 |
| 28555 | 28555 | e6200 | 3199 3199 |
| 28556 | 28556 | 3502d | 3199 3199 |
| 28557 | 28557 | b1201 | 3199 3199 |
| 28558 | 28558 | 04629 | 3199 3199 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)