This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5041 | 5041 | 0f722 | 2755 2755 |
| 5061 | 5061 | 0f722 | 2749 2749 |
| 5108 | 5108 | 0f722 | 2745 2745 |
| 5475 | 5475 | 0f722 | 2754 2754 |
| 5520 | 5520 | 0f722 | 2744 2744 |
| 5567 | 5567 | 0f722 | 2750 2750 |
| 6091 | 6091 | 0f722 | 2748 2748 |
| 6175 | 6175 | 0f722 | 2746 2746 |
| 6353 | 6353 | 0f722 | 2747 2747 |
| 6372 | 6372 | 0f722 | 2751 2751 |
| 6893 | 6893 | 0f722 | 2762 2762 |
| 6969 | 6969 | 0f722 | 2756 2756 |
| 7160 | 7160 | 0f722 | 2757 2757 |
| 7218 | 7218 | 0f722 | 2761 2761 |
| 7600 | 7600 | 0f722 | 2759 2759 |
| 7724 | 7724 | 0f722 | 2742 2742 |
| 7856 | 7856 | 0f722 | 2743 2743 |
| 8060 | 8060 | 0f722 | 2758 2758 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)