This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5375 | 5375 | aff2c | 1964 1964 |
| 36013 | 36013 | aff2c | 3513 3513 |
| 36027 | 36027 | aff2c | 3509 3509 |
| 36050 | 36050 | aff2c | 3508 3508 |
| 36071 | 36071 | aff2c | 3510 3510 |
| 36094 | 36094 | aff2c | 3514 3514 |
| 36154 | 36154 | aff2c | 3512 3512 |
| 36168 | 36168 | aff2c | 3506 3506 |
| 36296 | 36296 | aff2c | 3507 3507 |
| 36310 | 36310 | aff2c | 3511 3511 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)