This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36393 | 36393 | ec3ac | 3302 3302 |
| 36394 | 36394 | bcd9a | 3302 3302 |
| 36395 | 36395 | 371f0 | 3302 3302 |
| 36396 | 36396 | 5e075 | 3302 3302 |
| 36397 | 36397 | 59d75 | 3302 3302 |
| 36398 | 36398 | e6200 | 3302 3302 |
| 36399 | 36399 | b1201 | 3302 3302 |
| 36400 | 36400 | 902e5 | 3302 3302 |
| 36401 | 36401 | 372e7 | 3302 3302 |
| 36402 | 36402 | 2e713 | 3302 3302 |
| 36403 | 36403 | bbce5 | 3302 3302 |
| 36404 | 36404 | 934a1 | 3302 3302 |
| 36405 | 36405 | f7021 | 3302 3302 |
| 36406 | 36406 | cf71d | 3302 3302 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)