This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36228 | 36228 | cc5ed | 2999 2999 |
| 36229 | 36229 | 371f0 | 2999 2999 |
| 36230 | 36230 | e6200 | 2999 2999 |
| 36231 | 36231 | b1201 | 2999 2999 |
| 36232 | 36232 | 8a7ee | 2999 2999 |
| 36233 | 36233 | 862ed | 2999 2999 |
| 36234 | 36234 | 4d5c2 | 2999 2999 |
| 36235 | 36235 | 225c8 | 2999 2999 |
| 36236 | 36236 | 466b8 | 2999 2999 |
| 36237 | 36237 | 91181 | 2999 2999 |
| 36238 | 36238 | d723b | 2999 2999 |
| 36239 | 36239 | 87070 | 2999 2999 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)