This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17198 | 17198 | a26ae | 2962 2962 |
| 17199 | 17199 | c3503 | 2962 2962 |
| 17200 | 17200 | ec3ac | 2962 2962 |
| 17201 | 17201 | cb80d | 2962 2962 |
| 17202 | 17202 | 371f0 | 2962 2962 |
| 17203 | 17203 | 5e075 | 2962 2962 |
| 17204 | 17204 | 59d75 | 2962 2962 |
| 17205 | 17205 | e6200 | 2962 2962 |
| 17206 | 17206 | b1201 | 2962 2962 |
| 17207 | 17207 | 902e5 | 2962 2962 |
| 17208 | 17208 | 77d7e | 2962 2962 |
| 17209 | 17209 | af0a7 | 2962 2962 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)