This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22108 | 22108 | cc5ed | 2071 2071 |
| 22109 | 22109 | 371f0 | 2071 2071 |
| 22110 | 22110 | e6200 | 2071 2071 |
| 22111 | 22111 | b1201 | 2071 2071 |
| 22112 | 22112 | 8a7ee | 2071 2071 |
| 22113 | 22113 | 862ed | 2071 2071 |
| 22114 | 22114 | a1307 | 2071 2071 |
| 22115 | 22115 | abb72 | 2071 2071 |
| 22116 | 22116 | 27369 | 2071 2071 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)