This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5738 | 5738 | 2a4ca | 1670 1670 |
| 5811 | 5811 | 2a4ca | 1664 1664 |
| 6029 | 6029 | 2a4ca | 1634 1634 |
| 6224 | 6224 | 2a4ca | 1633 1633 |
| 6410 | 6410 | 2a4ca | 1671 1671 |
| 6474 | 6474 | 2a4ca | 1663 1663 |
| 6621 | 6621 | 2a4ca | 1619 1619 |
| 7322 | 7322 | 2a4ca | 1618 1618 |
| 12286 | 12286 | 2a4ca | 1951 1951 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)