This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11325 | 11325 | 2c267 | 1177 1177 |
| 11326 | 11326 | 2e411 | 1177 1177 |
| 11327 | 11327 | 371f0 | 1177 1177 |
| 11328 | 11328 | 5e075 | 1177 1177 |
| 11329 | 11329 | 59d75 | 1177 1177 |
| 11330 | 11330 | e6200 | 1177 1177 |
| 11331 | 11331 | b1201 | 1177 1177 |
| 11332 | 11332 | 9faf6 | 1177 1177 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)