This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7902 | 7902 | 189ac | 2283 2283 |
| 7903 | 7903 | 4801f | 2283 2283 |
| 7904 | 7904 | 5e075 | 2283 2283 |
| 7905 | 7905 | 59d75 | 2283 2283 |
| 7906 | 7906 | e6200 | 2283 2283 |
| 7907 | 7907 | b1201 | 2283 2283 |
| 7908 | 7908 | ad8b2 | 2283 2283 |
| 7909 | 7909 | 8a7ee | 2283 2283 |
| 7910 | 7910 | 862ed | 2283 2283 |
| 7911 | 7911 | 15db9 | 2283 2283 |
| 7912 | 7912 | 18a64 | 2283 2283 |
| 7913 | 7913 | 7c38f | 2283 2283 |
| 7914 | 7914 | bd3d9 | 2283 2283 |
| 7915 | 7915 | 27369 | 2283 2283 |
| 7916 | 7916 | 38705 | 2283 2283 |
| 7917 | 7917 | 1518e | 2283 2283 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)