This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5522 | 5522 | ec3ac | 1140 1140 |
| 5523 | 5523 | 17183 | 1140 1140 |
| 5524 | 5524 | afc04 | 1140 1140 |
| 5525 | 5525 | c4200 | 1140 1140 |
| 5526 | 5526 | 313af | 1140 1140 |
| 5527 | 5527 | ebe26 | 1140 1140 |
| 5528 | 5528 | aabe0 | 1140 1140 |
| 5529 | 5529 | 9e07c | 1140 1140 |
| 5530 | 5530 | 1073c | 1140 1140 |
| 5531 | 5531 | 4801f | 1140 1140 |
| 5532 | 5532 | 5e075 | 1140 1140 |
| 5533 | 5533 | 59d75 | 1140 1140 |
| 5534 | 5534 | e6200 | 1140 1140 |
| 5535 | 5535 | b1201 | 1140 1140 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)