This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36336 | 36336 | ec3ac | 3301 3301 |
| 36337 | 36337 | bcd9a | 3301 3301 |
| 36338 | 36338 | 371f0 | 3301 3301 |
| 36339 | 36339 | 5e075 | 3301 3301 |
| 36340 | 36340 | 59d75 | 3301 3301 |
| 36341 | 36341 | e6200 | 3301 3301 |
| 36342 | 36342 | b1201 | 3301 3301 |
| 36343 | 36343 | 902e5 | 3301 3301 |
| 36344 | 36344 | e158d | 3301 3301 |
| 36345 | 36345 | bbce5 | 3301 3301 |
| 36346 | 36346 | 934a1 | 3301 3301 |
| 36347 | 36347 | 386c6 | 3301 3301 |
| 36348 | 36348 | f7021 | 3301 3301 |
| 36349 | 36349 | cf71d | 3301 3301 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)