This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 19032 | 19032 | cc5ed | 2102 2102 |
| 19033 | 19033 | 371f0 | 2102 2102 |
| 19034 | 19034 | e6200 | 2102 2102 |
| 19035 | 19035 | b1201 | 2102 2102 |
| 19036 | 19036 | 8a7ee | 2102 2102 |
| 19037 | 19037 | 862ed | 2102 2102 |
| 19038 | 19038 | a1307 | 2102 2102 |
| 19039 | 19039 | abb72 | 2102 2102 |
| 19040 | 19040 | 27369 | 2102 2102 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)