This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9814 | 9814 | ec3ac | 894 894 |
| 9815 | 9815 | b668a | 894 894 |
| 9816 | 9816 | aaf5a | 894 894 |
| 9817 | 9817 | 5e075 | 894 894 |
| 9818 | 9818 | 59d75 | 894 894 |
| 9819 | 9819 | e6200 | 894 894 |
| 9820 | 9820 | b1201 | 894 894 |
| 9821 | 9821 | b42a4 | 894 894 |
| 9822 | 9822 | d679e | 894 894 |
| 9823 | 9823 | 17bc7 | 894 894 |
| 9824 | 9824 | aa04d | 894 894 |
| 9825 | 9825 | 95f91 | 894 894 |
| 9826 | 9826 | 7ce59 | 894 894 |
| 9827 | 9827 | a524c | 894 894 |
| 9828 | 9828 | 234f1 | 894 894 |
| 9829 | 9829 | 100b7 | 894 894 |
| 9830 | 9830 | 1518e | 894 894 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)