This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5175 | 5175 | ec3ac | 692 692 |
| 5176 | 5176 | c237c | 692 692 |
| 5177 | 5177 | 85029 | 692 692 |
| 5178 | 5178 | bf1e7 | 692 692 |
| 5179 | 5179 | 5e075 | 692 692 |
| 5180 | 5180 | 59d75 | 692 692 |
| 5181 | 5181 | e6200 | 692 692 |
| 5182 | 5182 | b1201 | 692 692 |
| 5183 | 5183 | 8123a | 692 692 |
| 5184 | 5184 | 5b456 | 692 692 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)