This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5034 | 5034 | 3fb0e | 2755 2755 |
| 5094 | 5094 | 3fb0e | 2745 2745 |
| 5508 | 5508 | 3fb0e | 2744 2744 |
| 6161 | 6161 | 3fb0e | 2746 2746 |
| 6958 | 6958 | 3fb0e | 2756 2756 |
| 7146 | 7146 | 3fb0e | 2757 2757 |
| 7848 | 7848 | 3fb0e | 2743 2743 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)