This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5172 | 5172 | a4c1d | 1635 1635 |
| 5283 | 5283 | a4c1d | 1665 1665 |
| 5453 | 5453 | a4c1d | 1672 1672 |
| 5753 | 5753 | a4c1d | 1670 1670 |
| 5828 | 5828 | a4c1d | 1664 1664 |
| 6046 | 6046 | a4c1d | 1634 1634 |
| 6239 | 6239 | a4c1d | 1633 1633 |
| 6427 | 6427 | a4c1d | 1671 1671 |
| 6489 | 6489 | a4c1d | 1663 1663 |
| 6638 | 6638 | a4c1d | 1619 1619 |
| 7274 | 7274 | a4c1d | 1620 1620 |
| 7337 | 7337 | a4c1d | 1618 1618 |
| 11690 | 11690 | a4c1d | 1902 1902 |
| 14645 | 14645 | a4c1d | 1919 1919 |
| 34817 | 34817 | a4c1d | 1915 1915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)