This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25203 | 25203 | cc5ed | 2131 2131 |
| 25204 | 25204 | 371f0 | 2131 2131 |
| 25205 | 25205 | e6200 | 2131 2131 |
| 25206 | 25206 | b1201 | 2131 2131 |
| 25207 | 25207 | 8a7ee | 2131 2131 |
| 25208 | 25208 | 862ed | 2131 2131 |
| 25209 | 25209 | a2d21 | 2131 2131 |
| 25210 | 25210 | 1d2ab | 2131 2131 |
| 25211 | 25211 | 4225c | 2131 2131 |
| 25212 | 25212 | 27369 | 2131 2131 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)