This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18520 | 18520 | ec3ac | 928 928 |
| 18521 | 18521 | 4801f | 928 928 |
| 18522 | 18522 | 5e075 | 928 928 |
| 18523 | 18523 | 59d75 | 928 928 |
| 18524 | 18524 | e6200 | 928 928 |
| 18525 | 18525 | b1201 | 928 928 |
| 18526 | 18526 | d6347 | 928 928 |
| 18527 | 18527 | ebf60 | 928 928 |
| 18528 | 18528 | 9a8c6 | 928 928 |
| 18529 | 18529 | 91693 | 928 928 |
| 18530 | 18530 | 1d2ab | 928 928 |
| 18531 | 18531 | abb72 | 928 928 |
| 18532 | 18532 | 41b26 | 928 928 |
| 18533 | 18533 | 2db78 | 928 928 |
| 18534 | 18534 | 6a38c | 928 928 |
| 18535 | 18535 | e128e | 928 928 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)