This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9735 | 9735 | c9d7f | 1080 1080 |
| 9844 | 9844 | c9d7f | 1081 1081 |
| 11218 | 11218 | c9d7f | 1085 1085 |
| 12523 | 12523 | c9d7f | 188 188 |
| 12575 | 12575 | c9d7f | 1796 1796 |
| 13089 | 13089 | c9d7f | 1091 1091 |
| 13765 | 13765 | c9d7f | 97 97 |
| 14620 | 14620 | c9d7f | 1236 1236 |
| 15369 | 15369 | c9d7f | 1233 1233 |
| 32359 | 32359 | c9d7f | 77 77 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)