This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5081 | 5081 | 40a0a | 3175 3175 |
| 6062 | 6062 | 40a0a | 691 691 |
| 7143 | 7143 | 40a0a | 3177 3177 |
| 7523 | 7523 | 40a0a | 2740 2740 |
| 7615 | 7615 | 40a0a | 686 686 |
| 7814 | 7814 | 40a0a | 3178 3178 |
| 9644 | 9644 | 40a0a | 1912 1912 |
| 9763 | 9763 | 40a0a | 1909 1909 |
| 10109 | 10109 | 40a0a | 1913 1913 |
| 10363 | 10363 | 40a0a | 1914 1914 |
| 10429 | 10429 | 40a0a | 1917 1917 |
| 11124 | 11124 | 40a0a | 1908 1908 |
| 30773 | 30773 | 40a0a | 469 469 |
| 30924 | 30924 | 40a0a | 468 468 |
| 31946 | 31946 | 40a0a | 1934 1934 |
| 34622 | 34622 | 40a0a | 1910 1910 |
| 35422 | 35422 | 40a0a | 1911 1911 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)