This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 28397 | 28397 | cdb88 | 2197 2197 |
| 28528 | 28528 | cdb88 | 2316 2316 |
| 28611 | 28611 | cdb88 | 2317 2317 |
| 28892 | 28892 | cdb88 | 2198 2198 |
| 29443 | 29443 | cdb88 | 2000 2000 |
| 29529 | 29529 | cdb88 | 2388 2388 |
| 29974 | 29974 | cdb88 | 2389 2389 |
| 30053 | 30053 | cdb88 | 1999 1999 |
| 34826 | 34826 | cdb88 | 2315 2315 |
| 34846 | 34846 | cdb88 | 2196 2196 |
| 35156 | 35156 | cdb88 | 2387 2387 |
| 35352 | 35352 | cdb88 | 1998 1998 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)