This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28010 | 28010 | cc5ed | 2473 2473 |
| 28011 | 28011 | 371f0 | 2473 2473 |
| 28012 | 28012 | e6200 | 2473 2473 |
| 28013 | 28013 | b1201 | 2473 2473 |
| 28014 | 28014 | 8a7ee | 2473 2473 |
| 28015 | 28015 | 862ed | 2473 2473 |
| 28016 | 28016 | d1aa5 | 2473 2473 |
| 28017 | 28017 | 2ce65 | 2473 2473 |
| 28018 | 28018 | 7746b | 2473 2473 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)