This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 15659 | 15659 | 189ac | 2373 2373 |
| 15660 | 15660 | 371f0 | 2373 2373 |
| 15661 | 15661 | e6200 | 2373 2373 |
| 15662 | 15662 | b1201 | 2373 2373 |
| 15663 | 15663 | 8a7ee | 2373 2373 |
| 15664 | 15664 | 862ed | 2373 2373 |
| 15665 | 15665 | a1307 | 2373 2373 |
| 15666 | 15666 | abb72 | 2373 2373 |
| 15667 | 15667 | 27369 | 2373 2373 |
| 15668 | 15668 | f9b79 | 2373 2373 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)