This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23194 | 23194 | cc5ed | 2082 2082 |
| 23195 | 23195 | 371f0 | 2082 2082 |
| 23196 | 23196 | e6200 | 2082 2082 |
| 23197 | 23197 | b1201 | 2082 2082 |
| 23198 | 23198 | 8a7ee | 2082 2082 |
| 23199 | 23199 | 862ed | 2082 2082 |
| 23200 | 23200 | a1307 | 2082 2082 |
| 23201 | 23201 | abb72 | 2082 2082 |
| 23202 | 23202 | 27369 | 2082 2082 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)