This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 24381 | 24381 | cc5ed | 2927 2927 |
| 24382 | 24382 | c1190 | 2927 2927 |
| 24383 | 24383 | cb80d | 2927 2927 |
| 24384 | 24384 | 371f0 | 2927 2927 |
| 24385 | 24385 | bf1e7 | 2927 2927 |
| 24386 | 24386 | e6200 | 2927 2927 |
| 24387 | 24387 | b1201 | 2927 2927 |
| 24388 | 24388 | 902e5 | 2927 2927 |
| 24389 | 24389 | b918e | 2927 2927 |
| 24390 | 24390 | 597b7 | 2927 2927 |
| 24391 | 24391 | 48ab1 | 2927 2927 |
| 24392 | 24392 | 83826 | 2927 2927 |
| 24393 | 24393 | 56bb6 | 2927 2927 |
| 24394 | 24394 | 927de | 2927 2927 |
| 24395 | 24395 | 25d0f | 2927 2927 |
| 24396 | 24396 | 35c78 | 2927 2927 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)