This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3067 | 3067 | 84f2d | 587 587 |
| 3344 | 3344 | 84f2d | 586 586 |
| 3434 | 3434 | 84f2d | 588 588 |
| 4060 | 4060 | 84f2d | 585 585 |
| 4291 | 4291 | 84f2d | 3394 3394 |
| 4439 | 4439 | 84f2d | 668 668 |
| 4520 | 4520 | 84f2d | 669 669 |
| 4640 | 4640 | 84f2d | 581 581 |
| 4680 | 4680 | 84f2d | 675 675 |
| 4706 | 4706 | 84f2d | 671 671 |
| 4735 | 4735 | 84f2d | 670 670 |
| 4760 | 4760 | 84f2d | 676 676 |
| 4786 | 4786 | 84f2d | 582 582 |
| 4829 | 4829 | 84f2d | 674 674 |
| 4849 | 4849 | 84f2d | 672 672 |
| 4880 | 4880 | 84f2d | 580 580 |
| 4908 | 4908 | 84f2d | 584 584 |
| 4944 | 4944 | 84f2d | 583 583 |
| 5000 | 5000 | 84f2d | 673 673 |
| 8326 | 8326 | 84f2d | 610 610 |
| 8455 | 8455 | 84f2d | 609 609 |
| 8528 | 8528 | 84f2d | 606 606 |
| 31121 | 31121 | 84f2d | 590 590 |
| 31149 | 31149 | 84f2d | 589 589 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)