This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 35381 | 35381 | b08d4 | 524 524 |
| 35382 | 35382 | 0b28b | 524 524 |
| 35383 | 35383 | 407d7 | 524 524 |
| 35384 | 35384 | 72f3e | 524 524 |
| 35385 | 35385 | e786b | 524 524 |
| 35386 | 35386 | 72597 | 524 524 |
| 35387 | 35387 | 371f0 | 524 524 |
| 35388 | 35388 | 5e075 | 524 524 |
| 35389 | 35389 | 59d75 | 524 524 |
| 35390 | 35390 | e6200 | 524 524 |
| 35391 | 35391 | b1201 | 524 524 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)