This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17368 | 17368 | cc5ed | 3289 3289 |
| 17369 | 17369 | 371f0 | 3289 3289 |
| 17370 | 17370 | e6200 | 3289 3289 |
| 17371 | 17371 | b1201 | 3289 3289 |
| 17372 | 17372 | 372e7 | 3289 3289 |
| 17373 | 17373 | bbce5 | 3289 3289 |
| 17374 | 17374 | 934a1 | 3289 3289 |
| 17375 | 17375 | f7021 | 3289 3289 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)