This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 31522 | 31522 | cc5ed | 1805 1805 |
| 31523 | 31523 | 0771c | 1805 1805 |
| 31524 | 31524 | cf58f | 1805 1805 |
| 31525 | 31525 | c3e59 | 1805 1805 |
| 31526 | 31526 | 46069 | 1805 1805 |
| 31527 | 31527 | 5e998 | 1805 1805 |
| 31528 | 31528 | e6200 | 1805 1805 |
| 31529 | 31529 | b1201 | 1805 1805 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)