This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36473 | 36473 | ec3ac | 3304 3304 |
| 36474 | 36474 | 371f0 | 3304 3304 |
| 36475 | 36475 | 5e075 | 3304 3304 |
| 36476 | 36476 | 59d75 | 3304 3304 |
| 36477 | 36477 | e6200 | 3304 3304 |
| 36478 | 36478 | b1201 | 3304 3304 |
| 36479 | 36479 | 902e5 | 3304 3304 |
| 36480 | 36480 | 372e7 | 3304 3304 |
| 36481 | 36481 | bbce5 | 3304 3304 |
| 36482 | 36482 | 934a1 | 3304 3304 |
| 36483 | 36483 | 386c6 | 3304 3304 |
| 36484 | 36484 | f7021 | 3304 3304 |
| 36485 | 36485 | cf71d | 3304 3304 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)