This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10537 | 10537 | 6e2b2 | 1436 1436 |
| 10538 | 10538 | b60e9 | 1436 1436 |
| 10539 | 10539 | cc756 | 1436 1436 |
| 10540 | 10540 | 5e075 | 1436 1436 |
| 10541 | 10541 | 59d75 | 1436 1436 |
| 10542 | 10542 | e6200 | 1436 1436 |
| 10543 | 10543 | b1201 | 1436 1436 |
| 10544 | 10544 | 8b9b7 | 1436 1436 |
| 10545 | 10545 | 4dc48 | 1436 1436 |
| 10546 | 10546 | 8d4bc | 1436 1436 |
| 10547 | 10547 | 53703 | 1436 1436 |
| 10548 | 10548 | ec55d | 1436 1436 |
| 10549 | 10549 | d379e | 1436 1436 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)