This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5039 | 5039 | 1e955 | 2755 2755 |
| 5102 | 5102 | 1e955 | 2745 2745 |
| 5473 | 5473 | 1e955 | 2754 2754 |
| 5515 | 5515 | 1e955 | 2744 2744 |
| 6085 | 6085 | 1e955 | 2748 2748 |
| 6116 | 6116 | 1e955 | 2752 2752 |
| 6169 | 6169 | 1e955 | 2746 2746 |
| 6347 | 6347 | 1e955 | 2747 2747 |
| 6367 | 6367 | 1e955 | 2751 2751 |
| 6887 | 6887 | 1e955 | 2762 2762 |
| 6964 | 6964 | 1e955 | 2756 2756 |
| 7153 | 7153 | 1e955 | 2757 2757 |
| 7593 | 7593 | 1e955 | 2759 2759 |
| 7722 | 7722 | 1e955 | 2742 2742 |
| 7854 | 7854 | 1e955 | 2743 2743 |
| 8053 | 8053 | 1e955 | 2758 2758 |
| 9712 | 9712 | 1e955 | 1941 1941 |
| 12071 | 12071 | 1e955 | 1944 1944 |
| 31991 | 31991 | 1e955 | 1929 1929 |
| 34604 | 34604 | 1e955 | 1930 1930 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)