This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 9472 | 9472 | cc5ed | 2390 2390 |
| 9473 | 9473 | 371f0 | 2390 2390 |
| 9474 | 9474 | e6200 | 2390 2390 |
| 9475 | 9475 | b1201 | 2390 2390 |
| 9476 | 9476 | 8a7ee | 2390 2390 |
| 9477 | 9477 | 862ed | 2390 2390 |
| 9478 | 9478 | a1307 | 2390 2390 |
| 9479 | 9479 | abb72 | 2390 2390 |
| 9480 | 9480 | 27369 | 2390 2390 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)