This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3731 | 3731 | 1ef30 | 101 101 |
| 3732 | 3732 | c448c | 101 101 |
| 3733 | 3733 | 69e43 | 101 101 |
| 3734 | 3734 | 18d8d | 101 101 |
| 3735 | 3735 | 6fba5 | 101 101 |
| 3736 | 3736 | 371f0 | 101 101 |
| 3737 | 3737 | 5e075 | 101 101 |
| 3738 | 3738 | 59d75 | 101 101 |
| 3739 | 3739 | e6200 | 101 101 |
| 3740 | 3740 | b1201 | 101 101 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)