This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36040 | 36040 | cc5ed | 3508 3508 |
| 36041 | 36041 | fa635 | 3508 3508 |
| 36042 | 36042 | e6200 | 3508 3508 |
| 36043 | 36043 | b1201 | 3508 3508 |
| 36044 | 36044 | a48a7 | 3508 3508 |
| 36045 | 36045 | dfca7 | 3508 3508 |
| 36046 | 36046 | c30e5 | 3508 3508 |
| 36047 | 36047 | 33643 | 3508 3508 |
| 36048 | 36048 | a65c5 | 3508 3508 |
| 36049 | 36049 | e456e | 3508 3508 |
| 36050 | 36050 | aff2c | 3508 3508 |
| 36051 | 36051 | bbd8e | 3508 3508 |
| 36052 | 36052 | 8bae1 | 3508 3508 |
| 36053 | 36053 | 4bc77 | 3508 3508 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)