This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34640 | 34640 | cc5ed | 1784 1784 |
| 34641 | 34641 | 371f0 | 1784 1784 |
| 34642 | 34642 | 59d75 | 1784 1784 |
| 34643 | 34643 | 3502d | 1784 1784 |
| 34644 | 34644 | 35592 | 1784 1784 |
| 34645 | 34645 | 21e56 | 1784 1784 |
| 34646 | 34646 | ac298 | 1784 1784 |
| 34647 | 34647 | 10832 | 1784 1784 |
| 34648 | 34648 | b07dd | 1784 1784 |
| 34649 | 34649 | 1bc6c | 1784 1784 |
| 34650 | 34650 | 93815 | 1784 1784 |
| 34651 | 34651 | 73e47 | 1784 1784 |
| 34652 | 34652 | 631df | 1784 1784 |
| 34653 | 34653 | aa5f3 | 1784 1784 |
| 34654 | 34654 | ecd47 | 1784 1784 |
| 34655 | 34655 | b9a5a | 1784 1784 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)