This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5734 | 5734 | bffb8 | 1670 1670 |
| 5807 | 5807 | bffb8 | 1664 1664 |
| 6025 | 6025 | bffb8 | 1634 1634 |
| 6220 | 6220 | bffb8 | 1633 1633 |
| 6406 | 6406 | bffb8 | 1671 1671 |
| 6470 | 6470 | bffb8 | 1663 1663 |
| 6617 | 6617 | bffb8 | 1619 1619 |
| 7318 | 7318 | bffb8 | 1618 1618 |
| 31547 | 31547 | bffb8 | 2444 2444 |
| 31844 | 31844 | bffb8 | 2440 2440 |
| 32168 | 32168 | bffb8 | 2443 2443 |
| 32449 | 32449 | bffb8 | 2439 2439 |
| 32638 | 32638 | bffb8 | 2441 2441 |
| 32982 | 32982 | bffb8 | 2442 2442 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)