This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5393 | 5393 | 48e80 | 2311 2311 |
| 5394 | 5394 | 4801f | 2311 2311 |
| 5395 | 5395 | 5e075 | 2311 2311 |
| 5396 | 5396 | 59d75 | 2311 2311 |
| 5397 | 5397 | 3502d | 2311 2311 |
| 5398 | 5398 | b1201 | 2311 2311 |
| 5399 | 5399 | 18a64 | 2311 2311 |
| 5400 | 5400 | 9295b | 2311 2311 |
| 5401 | 5401 | 31177 | 2311 2311 |
| 5402 | 5402 | 7c38f | 2311 2311 |
| 5403 | 5403 | 7ee91 | 2311 2311 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)