This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5580 | 5580 | cc5ed | 3014 3014 |
| 5581 | 5581 | 6060b | 3014 3014 |
| 5582 | 5582 | aaf5a | 3014 3014 |
| 5583 | 5583 | 59d75 | 3014 3014 |
| 5584 | 5584 | e6200 | 3014 3014 |
| 5585 | 5585 | b1201 | 3014 3014 |
| 5586 | 5586 | 902e5 | 3014 3014 |
| 5587 | 5587 | 8a7ee | 3014 3014 |
| 5588 | 5588 | 862ed | 3014 3014 |
| 5589 | 5589 | edcd8 | 3014 3014 |
| 5590 | 5590 | f6f14 | 3014 3014 |
| 5591 | 5591 | 18a64 | 3014 3014 |
| 5592 | 5592 | 225c8 | 3014 3014 |
| 5593 | 5593 | 85186 | 3014 3014 |
| 5594 | 5594 | cf4f6 | 3014 3014 |
| 5595 | 5595 | 3eb1f | 3014 3014 |
| 5596 | 5596 | 5b77d | 3014 3014 |
| 5597 | 5597 | 6f328 | 3014 3014 |
| 5598 | 5598 | 2ce65 | 3014 3014 |
| 5599 | 5599 | 9eb05 | 3014 3014 |
| 5600 | 5600 | 77050 | 3014 3014 |
| 5601 | 5601 | e4b8e | 3014 3014 |
| 5602 | 5602 | 838d3 | 3014 3014 |
| 5603 | 5603 | bd0bb | 3014 3014 |
| 5604 | 5604 | e128e | 3014 3014 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)