This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12686 | 12686 | 929ee | 3455 3455 |
| 12732 | 12732 | 929ee | 3449 3449 |
| 12831 | 12831 | 929ee | 3437 3437 |
| 12957 | 12957 | 929ee | 3448 3448 |
| 13035 | 13035 | 929ee | 3454 3454 |
| 13081 | 13081 | 929ee | 3450 3450 |
| 13127 | 13127 | 929ee | 3436 3436 |
| 13150 | 13150 | 929ee | 3442 3442 |
| 13323 | 13323 | 929ee | 3438 3438 |
| 13547 | 13547 | 929ee | 3443 3443 |
| 13611 | 13611 | 929ee | 3447 3447 |
| 14078 | 14078 | 929ee | 3432 3432 |
| 14107 | 14107 | 929ee | 3426 3426 |
| 14245 | 14245 | 929ee | 3468 3468 |
| 14288 | 14288 | 929ee | 3427 3427 |
| 14359 | 14359 | 929ee | 3431 3431 |
| 14658 | 14658 | 929ee | 3460 3460 |
| 14772 | 14772 | 929ee | 3467 3467 |
| 14965 | 14965 | 929ee | 3462 3462 |
| 15050 | 15050 | 929ee | 3456 3456 |
| 15175 | 15175 | 929ee | 3461 3461 |
| 15339 | 15339 | 929ee | 3466 3466 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)