This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 261 | 261 | 3bf90 | 3066 3066 |
| 437 | 437 | 3bf90 | 2381 2381 |
| 476 | 476 | 3bf90 | 3021 3021 |
| 597 | 597 | 3bf90 | 3043 3043 |
| 832 | 832 | 3bf90 | 3026 3026 |
| 1300 | 1300 | 3bf90 | 3072 3072 |
| 1607 | 1607 | 3bf90 | 2359 2359 |
| 2129 | 2129 | 3bf90 | 3046 3046 |
| 29096 | 29096 | 3bf90 | 3019 3019 |
| 29395 | 29395 | 3bf90 | 3029 3029 |
| 29543 | 29543 | 3bf90 | 3068 3068 |
| 30386 | 30386 | 3bf90 | 3060 3060 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)