This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 23404 | 23404 | cc5ed | 2134 2134 |
| 23405 | 23405 | 371f0 | 2134 2134 |
| 23406 | 23406 | e6200 | 2134 2134 |
| 23407 | 23407 | b1201 | 2134 2134 |
| 23408 | 23408 | 8a7ee | 2134 2134 |
| 23409 | 23409 | 862ed | 2134 2134 |
| 23410 | 23410 | a2d21 | 2134 2134 |
| 23411 | 23411 | a1307 | 2134 2134 |
| 23412 | 23412 | abb72 | 2134 2134 |
| 23413 | 23413 | 27369 | 2134 2134 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)