This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29821 | 29821 | cc5ed | 3030 3030 |
| 29822 | 29822 | 371f0 | 3030 3030 |
| 29823 | 29823 | e6200 | 3030 3030 |
| 29824 | 29824 | b1201 | 3030 3030 |
| 29825 | 29825 | 8a7ee | 3030 3030 |
| 29826 | 29826 | 862ed | 3030 3030 |
| 29827 | 29827 | 487f2 | 3030 3030 |
| 29828 | 29828 | 3fbed | 3030 3030 |
| 29829 | 29829 | 27369 | 3030 3030 |
| 29830 | 29830 | 04629 | 3030 3030 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)