This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29573 | 29573 | cc5ed | 2966 2966 |
| 29574 | 29574 | cb80d | 2966 2966 |
| 29575 | 29575 | 371f0 | 2966 2966 |
| 29576 | 29576 | 5e075 | 2966 2966 |
| 29577 | 29577 | 59d75 | 2966 2966 |
| 29578 | 29578 | e6200 | 2966 2966 |
| 29579 | 29579 | b1201 | 2966 2966 |
| 29580 | 29580 | 902e5 | 2966 2966 |
| 29581 | 29581 | 6ec75 | 2966 2966 |
| 29582 | 29582 | dbf07 | 2966 2966 |
| 29583 | 29583 | a40b9 | 2966 2966 |
| 29584 | 29584 | 25d0f | 2966 2966 |
| 29585 | 29585 | 06d39 | 2966 2966 |
| 29586 | 29586 | 4fcc4 | 2966 2966 |
| 29587 | 29587 | 35c78 | 2966 2966 |
| 29588 | 29588 | af0a7 | 2966 2966 |
| 29589 | 29589 | 09b01 | 2966 2966 |
| 29590 | 29590 | 87529 | 2966 2966 |
| 29591 | 29591 | 04182 | 2966 2966 |
| 29592 | 29592 | d6846 | 2966 2966 |
| 29593 | 29593 | a7f5a | 2966 2966 |
| 29594 | 29594 | 8e14c | 2966 2966 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)