This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 6606 | 6606 | c6b59 | 2287 2287 |
| 6607 | 6607 | 4801f | 2287 2287 |
| 6608 | 6608 | 5e075 | 2287 2287 |
| 6609 | 6609 | 59d75 | 2287 2287 |
| 6610 | 6610 | e6200 | 2287 2287 |
| 6611 | 6611 | b1201 | 2287 2287 |
| 6612 | 6612 | 18a64 | 2287 2287 |
| 6613 | 6613 | 9295b | 2287 2287 |
| 6614 | 6614 | 31177 | 2287 2287 |
| 6615 | 6615 | 7c38f | 2287 2287 |
| 6616 | 6616 | 7ee91 | 2287 2287 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)