This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36300 | 36300 | cc5ed | 3511 3511 |
| 36301 | 36301 | a27a2 | 3511 3511 |
| 36302 | 36302 | e6200 | 3511 3511 |
| 36303 | 36303 | b1201 | 3511 3511 |
| 36304 | 36304 | a48a7 | 3511 3511 |
| 36305 | 36305 | dfca7 | 3511 3511 |
| 36306 | 36306 | c30e5 | 3511 3511 |
| 36307 | 36307 | 33643 | 3511 3511 |
| 36308 | 36308 | a65c5 | 3511 3511 |
| 36309 | 36309 | e456e | 3511 3511 |
| 36310 | 36310 | aff2c | 3511 3511 |
| 36311 | 36311 | bbd8e | 3511 3511 |
| 36312 | 36312 | 8bae1 | 3511 3511 |
| 36313 | 36313 | d14fe | 3511 3511 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)