This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20617 | 20617 | cc5ed | 2578 2578 |
| 20618 | 20618 | 371f0 | 2578 2578 |
| 20619 | 20619 | e6200 | 2578 2578 |
| 20620 | 20620 | b1201 | 2578 2578 |
| 20621 | 20621 | d9d8c | 2578 2578 |
| 20622 | 20622 | 5f10e | 2578 2578 |
| 20623 | 20623 | 81cf6 | 2578 2578 |
| 20624 | 20624 | 5849a | 2578 2578 |
| 20625 | 20625 | eab5e | 2578 2578 |
| 20626 | 20626 | 8b401 | 2578 2578 |
| 20627 | 20627 | 007df | 2578 2578 |
| 20628 | 20628 | 5dcb2 | 2578 2578 |
| 20629 | 20629 | d3539 | 2578 2578 |
| 20630 | 20630 | 60626 | 2578 2578 |
| 20631 | 20631 | 4a957 | 2578 2578 |
| 20632 | 20632 | 839f9 | 2578 2578 |
| 20633 | 20633 | ffca2 | 2578 2578 |
| 20634 | 20634 | 4f89e | 2578 2578 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)