This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31830 | 31830 | 711dd | 1700 1700 |
| 31831 | 31831 | ca0eb | 1700 1700 |
| 31832 | 31832 | ac7e2 | 1700 1700 |
| 31833 | 31833 | 65b27 | 1700 1700 |
| 31834 | 31834 | 203d9 | 1700 1700 |
| 31835 | 31835 | 3502d | 1700 1700 |
| 31836 | 31836 | 18a64 | 1700 1700 |
| 31837 | 31837 | d65e1 | 1700 1700 |
| 31838 | 31838 | 7c38f | 1700 1700 |
| 31839 | 31839 | e42ca | 1700 1700 |
| 31840 | 31840 | 27369 | 1700 1700 |
| 31841 | 31841 | 7ee91 | 1700 1700 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)