This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23464 | 23464 | cc5ed | 2928 2928 |
| 23465 | 23465 | c1190 | 2928 2928 |
| 23466 | 23466 | cb80d | 2928 2928 |
| 23467 | 23467 | 371f0 | 2928 2928 |
| 23468 | 23468 | bf1e7 | 2928 2928 |
| 23469 | 23469 | e6200 | 2928 2928 |
| 23470 | 23470 | b1201 | 2928 2928 |
| 23471 | 23471 | 902e5 | 2928 2928 |
| 23472 | 23472 | b918e | 2928 2928 |
| 23473 | 23473 | 597b7 | 2928 2928 |
| 23474 | 23474 | 48ab1 | 2928 2928 |
| 23475 | 23475 | 83826 | 2928 2928 |
| 23476 | 23476 | 927de | 2928 2928 |
| 23477 | 23477 | 25d0f | 2928 2928 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)