This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 7139 | 7139 | cc5ed | 3177 3177 |
| 7140 | 7140 | 61c1a | 3177 3177 |
| 7141 | 7141 | e6200 | 3177 3177 |
| 7142 | 7142 | 902e5 | 3177 3177 |
| 7143 | 7143 | 40a0a | 3177 3177 |
| 7144 | 7144 | 85bb6 | 3177 3177 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)