This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18605 | 18605 | 1b3de | 1265 1265 |
| 18610 | 18610 | 1b3de | 2445 2445 |
| 18813 | 18813 | 1b3de | 1266 1266 |
| 18828 | 18828 | 1b3de | 2446 2446 |
| 18845 | 18845 | 1b3de | 1264 1264 |
| 19140 | 19140 | 1b3de | 1262 1262 |
| 19698 | 19698 | 1b3de | 1263 1263 |
| 19849 | 19849 | 1b3de | 2452 2452 |
| 19976 | 19976 | 1b3de | 2453 2453 |
| 20467 | 20467 | 1b3de | 2450 2450 |
| 20714 | 20714 | 1b3de | 2448 2448 |
| 20947 | 20947 | 1b3de | 2449 2449 |
| 31572 | 31572 | 1b3de | 1636 1636 |
| 31650 | 31650 | 1b3de | 1903 1903 |
| 35210 | 35210 | 1b3de | 1637 1637 |
| 35396 | 35396 | 1b3de | 1622 1622 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)