This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22149 | 22149 | cc5ed | 2638 2638 |
| 22150 | 22150 | 371f0 | 2638 2638 |
| 22151 | 22151 | e6200 | 2638 2638 |
| 22152 | 22152 | b1201 | 2638 2638 |
| 22153 | 22153 | 5f10e | 2638 2638 |
| 22154 | 22154 | 007df | 2638 2638 |
| 22155 | 22155 | d3539 | 2638 2638 |
| 22156 | 22156 | 60626 | 2638 2638 |
| 22157 | 22157 | 839f9 | 2638 2638 |
| 22158 | 22158 | ffca2 | 2638 2638 |
| 22159 | 22159 | 4f89e | 2638 2638 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)