This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 13928 | 13928 | b343d | 1644 1644 |
| 31698 | 31698 | b343d | 1628 1628 |
| 31818 | 31818 | b343d | 1627 1627 |
| 31862 | 31862 | b343d | 1648 1648 |
| 31961 | 31961 | b343d | 1626 1626 |
| 32021 | 32021 | b343d | 1649 1649 |
| 32321 | 32321 | b343d | 1673 1673 |
| 32729 | 32729 | b343d | 1642 1642 |
| 32771 | 32771 | b343d | 1625 1625 |
| 32838 | 32838 | b343d | 1623 1623 |
| 32965 | 32965 | b343d | 1647 1647 |
| 33199 | 33199 | b343d | 1624 1624 |
| 33216 | 33216 | b343d | 1645 1645 |
| 33278 | 33278 | b343d | 1646 1646 |
| 35209 | 35209 | b343d | 1637 1637 |
| 35229 | 35229 | b343d | 1639 1639 |
| 35438 | 35438 | b343d | 1638 1638 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)