This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11296 | 11296 | ed356 | 897 897 |
| 11389 | 11389 | ed356 | 837 837 |
| 15301 | 15301 | ed356 | 869 869 |
| 31596 | 31596 | ed356 | 832 832 |
| 33452 | 33452 | ed356 | 921 921 |
| 33678 | 33678 | ed356 | 918 918 |
| 33707 | 33707 | ed356 | 922 922 |
| 33752 | 33752 | ed356 | 923 923 |
| 33994 | 33994 | ed356 | 911 911 |
| 34013 | 34013 | ed356 | 915 915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)