This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 32517 | 32517 | ec3ac | 1846 1846 |
| 32518 | 32518 | 398aa | 1846 1846 |
| 32519 | 32519 | 18789 | 1846 1846 |
| 32520 | 32520 | 49bfd | 1846 1846 |
| 32521 | 32521 | 371f0 | 1846 1846 |
| 32522 | 32522 | e6200 | 1846 1846 |
| 32523 | 32523 | b1201 | 1846 1846 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)