This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 32422 | 32422 | ec3ac | 1726 1726 |
| 32423 | 32423 | cf58f | 1726 1726 |
| 32424 | 32424 | c3e59 | 1726 1726 |
| 32425 | 32425 | 46069 | 1726 1726 |
| 32426 | 32426 | 5e998 | 1726 1726 |
| 32427 | 32427 | 00d26 | 1726 1726 |
| 32428 | 32428 | e6200 | 1726 1726 |
| 32429 | 32429 | b1201 | 1726 1726 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)