This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 14109 | 14109 | ec3ac | 3476 3476 |
| 14110 | 14110 | 9dfd5 | 3476 3476 |
| 14111 | 14111 | bf1e7 | 3476 3476 |
| 14112 | 14112 | 5e075 | 3476 3476 |
| 14113 | 14113 | 59d75 | 3476 3476 |
| 14114 | 14114 | e6200 | 3476 3476 |
| 14115 | 14115 | 26bad | 3476 3476 |
| 14116 | 14116 | 77f6e | 3476 3476 |
| 14117 | 14117 | 658c9 | 3476 3476 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)