This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 26256 | 26256 | cc5ed | 2864 2864 |
| 26257 | 26257 | 3da9b | 2864 2864 |
| 26258 | 26258 | 371f0 | 2864 2864 |
| 26259 | 26259 | 5e075 | 2864 2864 |
| 26260 | 26260 | 59d75 | 2864 2864 |
| 26261 | 26261 | e6200 | 2864 2864 |
| 26262 | 26262 | b1201 | 2864 2864 |
| 26263 | 26263 | 8a7ee | 2864 2864 |
| 26264 | 26264 | 862ed | 2864 2864 |
| 26265 | 26265 | f788a | 2864 2864 |
| 26266 | 26266 | 9848a | 2864 2864 |
| 26267 | 26267 | abb72 | 2864 2864 |
| 26268 | 26268 | 27369 | 2864 2864 |
| 26269 | 26269 | e128e | 2864 2864 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)