This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5042 | 5042 | 984e7 | 2755 2755 |
| 5062 | 5062 | 984e7 | 2749 2749 |
| 5109 | 5109 | 984e7 | 2745 2745 |
| 5476 | 5476 | 984e7 | 2754 2754 |
| 5521 | 5521 | 984e7 | 2744 2744 |
| 5568 | 5568 | 984e7 | 2750 2750 |
| 6092 | 6092 | 984e7 | 2748 2748 |
| 6176 | 6176 | 984e7 | 2746 2746 |
| 6354 | 6354 | 984e7 | 2747 2747 |
| 6373 | 6373 | 984e7 | 2751 2751 |
| 6894 | 6894 | 984e7 | 2762 2762 |
| 6970 | 6970 | 984e7 | 2756 2756 |
| 7161 | 7161 | 984e7 | 2757 2757 |
| 7219 | 7219 | 984e7 | 2761 2761 |
| 7601 | 7601 | 984e7 | 2759 2759 |
| 7725 | 7725 | 984e7 | 2742 2742 |
| 7857 | 7857 | 984e7 | 2743 2743 |
| 8061 | 8061 | 984e7 | 2758 2758 |
| 8181 | 8181 | 984e7 | 2760 2760 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)