This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 20727 | 20727 | cc5ed | 2597 2597 |
| 20728 | 20728 | 371f0 | 2597 2597 |
| 20729 | 20729 | e6200 | 2597 2597 |
| 20730 | 20730 | b1201 | 2597 2597 |
| 20731 | 20731 | d9d8c | 2597 2597 |
| 20732 | 20732 | 5f10e | 2597 2597 |
| 20733 | 20733 | 81cf6 | 2597 2597 |
| 20734 | 20734 | 5849a | 2597 2597 |
| 20735 | 20735 | eab5e | 2597 2597 |
| 20736 | 20736 | 8b401 | 2597 2597 |
| 20737 | 20737 | 007df | 2597 2597 |
| 20738 | 20738 | 5dcb2 | 2597 2597 |
| 20739 | 20739 | d3539 | 2597 2597 |
| 20740 | 20740 | 60626 | 2597 2597 |
| 20741 | 20741 | 4a957 | 2597 2597 |
| 20742 | 20742 | 839f9 | 2597 2597 |
| 20743 | 20743 | ffca2 | 2597 2597 |
| 20744 | 20744 | 4f89e | 2597 2597 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)