This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21625 | 21625 | cc5ed | 2938 2938 |
| 21626 | 21626 | cb80d | 2938 2938 |
| 21627 | 21627 | 371f0 | 2938 2938 |
| 21628 | 21628 | e6200 | 2938 2938 |
| 21629 | 21629 | b1201 | 2938 2938 |
| 21630 | 21630 | 902e5 | 2938 2938 |
| 21631 | 21631 | 7a98f | 2938 2938 |
| 21632 | 21632 | a40b9 | 2938 2938 |
| 21633 | 21633 | 56bb6 | 2938 2938 |
| 21634 | 21634 | 927de | 2938 2938 |
| 21635 | 21635 | fd049 | 2938 2938 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)