This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 17457 | 17457 | c4d21 | 3356 3356 |
| 17458 | 17458 | 7b150 | 3356 3356 |
| 17459 | 17459 | e6200 | 3356 3356 |
| 17460 | 17460 | b1201 | 3356 3356 |
| 17461 | 17461 | d3559 | 3356 3356 |
| 17462 | 17462 | df1f0 | 3356 3356 |
| 17463 | 17463 | 1d2ab | 3356 3356 |
| 17464 | 17464 | f431c | 3356 3356 |
| 17465 | 17465 | e4356 | 3356 3356 |
| 17466 | 17466 | 27369 | 3356 3356 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)