This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 22294 | 22294 | cc5ed | 1975 1975 |
| 22295 | 22295 | 371f0 | 1975 1975 |
| 22296 | 22296 | e6200 | 1975 1975 |
| 22297 | 22297 | b1201 | 1975 1975 |
| 22298 | 22298 | 8a7ee | 1975 1975 |
| 22299 | 22299 | 862ed | 1975 1975 |
| 22300 | 22300 | a1307 | 1975 1975 |
| 22301 | 22301 | abb72 | 1975 1975 |
| 22302 | 22302 | 27369 | 1975 1975 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)