This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15629 | 15629 | a8e8b | 3377 3377 |
| 15630 | 15630 | 7b150 | 3377 3377 |
| 15631 | 15631 | 5e075 | 3377 3377 |
| 15632 | 15632 | 59d75 | 3377 3377 |
| 15633 | 15633 | e6200 | 3377 3377 |
| 15634 | 15634 | b1201 | 3377 3377 |
| 15635 | 15635 | 8a7ee | 3377 3377 |
| 15636 | 15636 | 862ed | 3377 3377 |
| 15637 | 15637 | 13ab6 | 3377 3377 |
| 15638 | 15638 | 18a64 | 3377 3377 |
| 15639 | 15639 | 66f82 | 3377 3377 |
| 15640 | 15640 | f788a | 3377 3377 |
| 15641 | 15641 | 7c38f | 3377 3377 |
| 15642 | 15642 | df1f0 | 3377 3377 |
| 15643 | 15643 | a1307 | 3377 3377 |
| 15644 | 15644 | 809af | 3377 3377 |
| 15645 | 15645 | 4225c | 3377 3377 |
| 15646 | 15646 | 93975 | 3377 3377 |
| 15647 | 15647 | 04e82 | 3377 3377 |
| 15648 | 15648 | 94bdc | 3377 3377 |
| 15649 | 15649 | 9c206 | 3377 3377 |
| 15650 | 15650 | 7c580 | 3377 3377 |
| 15651 | 15651 | 724f8 | 3377 3377 |
| 15652 | 15652 | b6f60 | 3377 3377 |
| 15653 | 15653 | 06d39 | 3377 3377 |
| 15654 | 15654 | 2ab82 | 3377 3377 |
| 15655 | 15655 | 8b0bf | 3377 3377 |
| 15656 | 15656 | 01e8a | 3377 3377 |
| 15657 | 15657 | 2aa57 | 3377 3377 |
| 15658 | 15658 | 425d7 | 3377 3377 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)