This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 141 | 141 | bbdfd | 2827 2827 |
| 573 | 573 | bbdfd | 2828 2828 |
| 19081 | 19081 | bbdfd | 2821 2821 |
| 19419 | 19419 | bbdfd | 2842 2842 |
| 28411 | 28411 | bbdfd | 3236 3236 |
| 28825 | 28825 | bbdfd | 3237 3237 |
| 28884 | 28884 | bbdfd | 3235 3235 |
| 29041 | 29041 | bbdfd | 3233 3233 |
| 29158 | 29158 | bbdfd | 3234 3234 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)