This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16293 | 16293 | cc5ed | 2785 2785 |
| 16294 | 16294 | cba3e | 2785 2785 |
| 16295 | 16295 | 7b72e | 2785 2785 |
| 16296 | 16296 | e6200 | 2785 2785 |
| 16297 | 16297 | b1201 | 2785 2785 |
| 16298 | 16298 | 902e5 | 2785 2785 |
| 16299 | 16299 | 7e7c6 | 2785 2785 |
| 16300 | 16300 | 4f54f | 2785 2785 |
| 16301 | 16301 | db9ea | 2785 2785 |
| 16302 | 16302 | 8751c | 2785 2785 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)