This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29287 | 29287 | cc5ed | 3285 3285 |
| 29288 | 29288 | 7b150 | 3285 3285 |
| 29289 | 29289 | e6200 | 3285 3285 |
| 29290 | 29290 | b1201 | 3285 3285 |
| 29291 | 29291 | 23cb3 | 3285 3285 |
| 29292 | 29292 | 177f3 | 3285 3285 |
| 29293 | 29293 | fbd4b | 3285 3285 |
| 29294 | 29294 | bd053 | 3285 3285 |
| 29295 | 29295 | 7f52f | 3285 3285 |
| 29296 | 29296 | d0dd5 | 3285 3285 |
| 29297 | 29297 | cde92 | 3285 3285 |
| 29298 | 29298 | d6373 | 3285 3285 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)