This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9256 | 9256 | d980a | 1427 1427 |
| 9370 | 9370 | d980a | 1927 1927 |
| 31131 | 31131 | d980a | 1879 1879 |
| 31159 | 31159 | d980a | 1883 1883 |
| 31195 | 31195 | d980a | 314 314 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)