This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25661 | 25661 | cc5ed | 2904 2904 |
| 25662 | 25662 | c1190 | 2904 2904 |
| 25663 | 25663 | cb80d | 2904 2904 |
| 25664 | 25664 | 371f0 | 2904 2904 |
| 25665 | 25665 | bf1e7 | 2904 2904 |
| 25666 | 25666 | e6200 | 2904 2904 |
| 25667 | 25667 | b1201 | 2904 2904 |
| 25668 | 25668 | 902e5 | 2904 2904 |
| 25669 | 25669 | b918e | 2904 2904 |
| 25670 | 25670 | 46d55 | 2904 2904 |
| 25671 | 25671 | 0e9bf | 2904 2904 |
| 25672 | 25672 | edcd8 | 2904 2904 |
| 25673 | 25673 | 22093 | 2904 2904 |
| 25674 | 25674 | e0e2d | 2904 2904 |
| 25675 | 25675 | f187d | 2904 2904 |
| 25676 | 25676 | 99241 | 2904 2904 |
| 25677 | 25677 | 4a7fd | 2904 2904 |
| 25678 | 25678 | 927de | 2904 2904 |
| 25679 | 25679 | 25d0f | 2904 2904 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)