This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21070 | 21070 | cc5ed | 2624 2624 |
| 21071 | 21071 | 371f0 | 2624 2624 |
| 21072 | 21072 | e6200 | 2624 2624 |
| 21073 | 21073 | b1201 | 2624 2624 |
| 21074 | 21074 | 5f10e | 2624 2624 |
| 21075 | 21075 | 007df | 2624 2624 |
| 21076 | 21076 | d3539 | 2624 2624 |
| 21077 | 21077 | 60626 | 2624 2624 |
| 21078 | 21078 | 839f9 | 2624 2624 |
| 21079 | 21079 | ffca2 | 2624 2624 |
| 21080 | 21080 | 4f89e | 2624 2624 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)