This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16668 | 16668 | ec3ac | 3385 3385 |
| 16669 | 16669 | e5946 | 3385 3385 |
| 16670 | 16670 | 95ebf | 3385 3385 |
| 16671 | 16671 | 59d75 | 3385 3385 |
| 16672 | 16672 | e6200 | 3385 3385 |
| 16673 | 16673 | 3502d | 3385 3385 |
| 16674 | 16674 | b1201 | 3385 3385 |
| 16675 | 16675 | b85e0 | 3385 3385 |
| 16676 | 16676 | a0884 | 3385 3385 |
| 16677 | 16677 | 2300e | 3385 3385 |
| 16678 | 16678 | 73272 | 3385 3385 |
| 16679 | 16679 | 6f82c | 3385 3385 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)