This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3431 | 3431 | ec3ac | 588 588 |
| 3432 | 3432 | 1021f | 588 588 |
| 3433 | 3433 | eed19 | 588 588 |
| 3434 | 3434 | 84f2d | 588 588 |
| 3435 | 3435 | f8d8c | 588 588 |
| 3436 | 3436 | 0524b | 588 588 |
| 3437 | 3437 | 0b2ab | 588 588 |
| 3438 | 3438 | 371f0 | 588 588 |
| 3439 | 3439 | 5e075 | 588 588 |
| 3440 | 3440 | 59d75 | 588 588 |
| 3441 | 3441 | e6200 | 588 588 |
| 3442 | 3442 | b1201 | 588 588 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)