This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 32838 | 32838 | b343d | 1623 1623 |
| 32839 | 32839 | 7be83 | 1623 1623 |
| 32840 | 32840 | 0733f | 1623 1623 |
| 32841 | 32841 | a30e4 | 1623 1623 |
| 32842 | 32842 | 5e075 | 1623 1623 |
| 32843 | 32843 | a4abf | 1623 1623 |
| 32844 | 32844 | 59d75 | 1623 1623 |
| 32845 | 32845 | e6200 | 1623 1623 |
| 32846 | 32846 | b1201 | 1623 1623 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)