This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22209 | 22209 | cc5ed | 2085 2085 |
| 22210 | 22210 | 371f0 | 2085 2085 |
| 22211 | 22211 | e6200 | 2085 2085 |
| 22212 | 22212 | b1201 | 2085 2085 |
| 22213 | 22213 | 8a7ee | 2085 2085 |
| 22214 | 22214 | 862ed | 2085 2085 |
| 22215 | 22215 | a2d21 | 2085 2085 |
| 22216 | 22216 | a1307 | 2085 2085 |
| 22217 | 22217 | abb72 | 2085 2085 |
| 22218 | 22218 | 27369 | 2085 2085 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)