This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 19300 | 19300 | a5ab5 | 2068 2068 |
| 22395 | 22395 | a5ab5 | 3328 3328 |
| 22692 | 22692 | a5ab5 | 3368 3368 |
| 23838 | 23838 | a5ab5 | 940 940 |
| 25271 | 25271 | a5ab5 | 3343 3343 |
| 27236 | 27236 | a5ab5 | 1037 1037 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)