This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11674 | 11674 | ecdee | 1902 1902 |
| 31707 | 31707 | ecdee | 1628 1628 |
| 31827 | 31827 | ecdee | 1627 1627 |
| 31870 | 31870 | ecdee | 1648 1648 |
| 31969 | 31969 | ecdee | 1626 1626 |
| 32030 | 32030 | ecdee | 1649 1649 |
| 33208 | 33208 | ecdee | 1624 1624 |
| 33287 | 33287 | ecdee | 1646 1646 |
| 34814 | 34814 | ecdee | 1915 1915 |
| 35218 | 35218 | ecdee | 1637 1637 |
| 35237 | 35237 | ecdee | 1639 1639 |
| 35446 | 35446 | ecdee | 1638 1638 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)