This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11279 | 11279 | ec3ac | 897 897 |
| 11280 | 11280 | 59b7b | 897 897 |
| 11281 | 11281 | aaf5a | 897 897 |
| 11282 | 11282 | 5e075 | 897 897 |
| 11283 | 11283 | 59d75 | 897 897 |
| 11284 | 11284 | e6200 | 897 897 |
| 11285 | 11285 | b1201 | 897 897 |
| 11286 | 11286 | 63e96 | 897 897 |
| 11287 | 11287 | 2fb27 | 897 897 |
| 11288 | 11288 | 7a351 | 897 897 |
| 11289 | 11289 | 0593a | 897 897 |
| 11290 | 11290 | eecd9 | 897 897 |
| 11291 | 11291 | 7ce59 | 897 897 |
| 11292 | 11292 | 4a30c | 897 897 |
| 11293 | 11293 | 3896c | 897 897 |
| 11294 | 11294 | a524c | 897 897 |
| 11295 | 11295 | 41ee7 | 897 897 |
| 11296 | 11296 | ed356 | 897 897 |
| 11297 | 11297 | 94bdc | 897 897 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)