This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5643 | 5643 | ec3ac | 1101 1101 |
| 5644 | 5644 | 96bbd | 1101 1101 |
| 5645 | 5645 | 313af | 1101 1101 |
| 5646 | 5646 | ebe26 | 1101 1101 |
| 5647 | 5647 | 1073c | 1101 1101 |
| 5648 | 5648 | 4801f | 1101 1101 |
| 5649 | 5649 | 5e075 | 1101 1101 |
| 5650 | 5650 | 59d75 | 1101 1101 |
| 5651 | 5651 | e6200 | 1101 1101 |
| 5652 | 5652 | b1201 | 1101 1101 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)