This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23379 | 23379 | cc5ed | 2926 2926 |
| 23380 | 23380 | c1190 | 2926 2926 |
| 23381 | 23381 | cb80d | 2926 2926 |
| 23382 | 23382 | 371f0 | 2926 2926 |
| 23383 | 23383 | bf1e7 | 2926 2926 |
| 23384 | 23384 | e6200 | 2926 2926 |
| 23385 | 23385 | b1201 | 2926 2926 |
| 23386 | 23386 | 902e5 | 2926 2926 |
| 23387 | 23387 | b918e | 2926 2926 |
| 23388 | 23388 | 597b7 | 2926 2926 |
| 23389 | 23389 | 48ab1 | 2926 2926 |
| 23390 | 23390 | 83826 | 2926 2926 |
| 23391 | 23391 | 56bb6 | 2926 2926 |
| 23392 | 23392 | 927de | 2926 2926 |
| 23393 | 23393 | 35c78 | 2926 2926 |
| 23394 | 23394 | fd049 | 2926 2926 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)