This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 25575 | 25575 | cc5ed | 2918 2918 |
| 25576 | 25576 | cb80d | 2918 2918 |
| 25577 | 25577 | 371f0 | 2918 2918 |
| 25578 | 25578 | e6200 | 2918 2918 |
| 25579 | 25579 | b1201 | 2918 2918 |
| 25580 | 25580 | 902e5 | 2918 2918 |
| 25581 | 25581 | 7a98f | 2918 2918 |
| 25582 | 25582 | a40b9 | 2918 2918 |
| 25583 | 25583 | 56bb6 | 2918 2918 |
| 25584 | 25584 | 927de | 2918 2918 |
| 25585 | 25585 | fd049 | 2918 2918 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)