This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 19514 | 19514 | cc5ed | 2067 2067 |
| 19515 | 19515 | 371f0 | 2067 2067 |
| 19516 | 19516 | e6200 | 2067 2067 |
| 19517 | 19517 | b1201 | 2067 2067 |
| 19518 | 19518 | 8a7ee | 2067 2067 |
| 19519 | 19519 | 862ed | 2067 2067 |
| 19520 | 19520 | a1307 | 2067 2067 |
| 19521 | 19521 | abb72 | 2067 2067 |
| 19522 | 19522 | 27369 | 2067 2067 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)