This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 2285 | 2285 | fb88d | 1069 1069 |
| 2286 | 2286 | 28463 | 1069 1069 |
| 2287 | 2287 | 8d659 | 1069 1069 |
| 2288 | 2288 | 9dc02 | 1069 1069 |
| 2289 | 2289 | 16ae8 | 1069 1069 |
| 2290 | 2290 | 1a869 | 1069 1069 |
| 2291 | 2291 | 0e564 | 1069 1069 |
| 2292 | 2292 | 36ca5 | 1069 1069 |
| 2293 | 2293 | e95f6 | 1069 1069 |
| 2294 | 2294 | 9ff24 | 1069 1069 |
| 2295 | 2295 | e6200 | 1069 1069 |
| 2296 | 2296 | b1201 | 1069 1069 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)