This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 34665 | 34665 | ec3ac | 1229 1229 |
| 34666 | 34666 | d6ade | 1229 1229 |
| 34667 | 34667 | 8e7b3 | 1229 1229 |
| 34668 | 34668 | f6644 | 1229 1229 |
| 34669 | 34669 | 8da48 | 1229 1229 |
| 34670 | 34670 | 6dfca | 1229 1229 |
| 34671 | 34671 | 872c3 | 1229 1229 |
| 34672 | 34672 | a0f55 | 1229 1229 |
| 34673 | 34673 | 371f0 | 1229 1229 |
| 34674 | 34674 | e6200 | 1229 1229 |
| 34675 | 34675 | b1201 | 1229 1229 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)