This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17126 | 17126 | ec3ac | 1075 1075 |
| 17127 | 17127 | 4801f | 1075 1075 |
| 17128 | 17128 | 5e075 | 1075 1075 |
| 17129 | 17129 | 59d75 | 1075 1075 |
| 17130 | 17130 | e6200 | 1075 1075 |
| 17131 | 17131 | b1201 | 1075 1075 |
| 17132 | 17132 | d6347 | 1075 1075 |
| 17133 | 17133 | ebf60 | 1075 1075 |
| 17134 | 17134 | 9a8c6 | 1075 1075 |
| 17135 | 17135 | 91693 | 1075 1075 |
| 17136 | 17136 | 1d2ab | 1075 1075 |
| 17137 | 17137 | abb72 | 1075 1075 |
| 17138 | 17138 | 41b26 | 1075 1075 |
| 17139 | 17139 | 2db78 | 1075 1075 |
| 17140 | 17140 | 6a38c | 1075 1075 |
| 17141 | 17141 | e128e | 1075 1075 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)