This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5150 | 5150 | ec3ac | 2997 2997 |
| 5151 | 5151 | d68b2 | 2997 2997 |
| 5152 | 5152 | dd539 | 2997 2997 |
| 5153 | 5153 | 5e075 | 2997 2997 |
| 5154 | 5154 | 59d75 | 2997 2997 |
| 5155 | 5155 | e6200 | 2997 2997 |
| 5156 | 5156 | b1201 | 2997 2997 |
| 5157 | 5157 | 7dde7 | 2997 2997 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)