This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 8568 | 8568 | cc5ed | 563 563 |
| 8569 | 8569 | 371f0 | 563 563 |
| 8570 | 8570 | e6200 | 563 563 |
| 8571 | 8571 | b1201 | 563 563 |
| 8572 | 8572 | 022da | 563 563 |
| 8573 | 8573 | 4e13d | 563 563 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)