This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 30337 | 30337 | cc5ed | 2645 2645 |
| 30338 | 30338 | ef21b | 2645 2645 |
| 30339 | 30339 | dcc45 | 2645 2645 |
| 30340 | 30340 | ffb7e | 2645 2645 |
| 30341 | 30341 | 2d239 | 2645 2645 |
| 30342 | 30342 | 83f98 | 2645 2645 |
| 30343 | 30343 | 29a48 | 2645 2645 |
| 30344 | 30344 | 2ed33 | 2645 2645 |
| 30345 | 30345 | 4801f | 2645 2645 |
| 30346 | 30346 | d2747 | 2645 2645 |
| 30347 | 30347 | 5e075 | 2645 2645 |
| 30348 | 30348 | 59d75 | 2645 2645 |
| 30349 | 30349 | f9d07 | 2645 2645 |
| 30350 | 30350 | e6200 | 2645 2645 |
| 30351 | 30351 | b1201 | 2645 2645 |
| 30352 | 30352 | 902e5 | 2645 2645 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)