This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 36016 | 36016 | 4bc77 | 3513 3513 |
| 36030 | 36030 | 4bc77 | 3509 3509 |
| 36053 | 36053 | 4bc77 | 3508 3508 |
| 36074 | 36074 | 4bc77 | 3510 3510 |
| 36097 | 36097 | 4bc77 | 3514 3514 |
| 36157 | 36157 | 4bc77 | 3512 3512 |
| 36171 | 36171 | 4bc77 | 3506 3506 |
| 36299 | 36299 | 4bc77 | 3507 3507 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)