This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29081 | 29081 | ec3ac | 3012 3012 |
| 29082 | 29082 | 6060b | 3012 3012 |
| 29083 | 29083 | 371f0 | 3012 3012 |
| 29084 | 29084 | 59d75 | 3012 3012 |
| 29085 | 29085 | e6200 | 3012 3012 |
| 29086 | 29086 | b1201 | 3012 3012 |
| 29087 | 29087 | 902e5 | 3012 3012 |
| 29088 | 29088 | 8a7ee | 3012 3012 |
| 29089 | 29089 | 862ed | 3012 3012 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)