This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15691 | 15691 | 189ac | 2365 2365 |
| 15692 | 15692 | 371f0 | 2365 2365 |
| 15693 | 15693 | e6200 | 2365 2365 |
| 15694 | 15694 | b1201 | 2365 2365 |
| 15695 | 15695 | 5e6f8 | 2365 2365 |
| 15696 | 15696 | 463ae | 2365 2365 |
| 15697 | 15697 | 93324 | 2365 2365 |
| 15698 | 15698 | f9b79 | 2365 2365 |
| 15699 | 15699 | 06ae5 | 2365 2365 |
| 15700 | 15700 | 710d1 | 2365 2365 |
| 15701 | 15701 | e737a | 2365 2365 |
| 15702 | 15702 | c45c4 | 2365 2365 |
| 15703 | 15703 | 60bee | 2365 2365 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)