This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5049 | 5049 | 74b62 | 2749 2749 |
| 5098 | 5098 | 74b62 | 2745 2745 |
| 5512 | 5512 | 74b62 | 2744 2744 |
| 5555 | 5555 | 74b62 | 2750 2750 |
| 6079 | 6079 | 74b62 | 2748 2748 |
| 6111 | 6111 | 74b62 | 2752 2752 |
| 6165 | 6165 | 74b62 | 2746 2746 |
| 6343 | 6343 | 74b62 | 2747 2747 |
| 6362 | 6362 | 74b62 | 2751 2751 |
| 6882 | 6882 | 74b62 | 2762 2762 |
| 6961 | 6961 | 74b62 | 2756 2756 |
| 7149 | 7149 | 74b62 | 2757 2757 |
| 7205 | 7205 | 74b62 | 2761 2761 |
| 7587 | 7587 | 74b62 | 2759 2759 |
| 8049 | 8049 | 74b62 | 2758 2758 |
| 8167 | 8167 | 74b62 | 2760 2760 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)