This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17627 | 17627 | ec3ac | 2767 2767 |
| 17628 | 17628 | 3909d | 2767 2767 |
| 17629 | 17629 | 371f0 | 2767 2767 |
| 17630 | 17630 | 5e075 | 2767 2767 |
| 17631 | 17631 | 59d75 | 2767 2767 |
| 17632 | 17632 | e6200 | 2767 2767 |
| 17633 | 17633 | b1201 | 2767 2767 |
| 17634 | 17634 | 902e5 | 2767 2767 |
| 17635 | 17635 | e80cf | 2767 2767 |
| 17636 | 17636 | 3e75a | 2767 2767 |
| 17637 | 17637 | e086a | 2767 2767 |
| 17638 | 17638 | c48f9 | 2767 2767 |
| 17639 | 17639 | 90531 | 2767 2767 |
| 17640 | 17640 | d5d34 | 2767 2767 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)