This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 3749 | 3749 | 72c69 | 115 115 |
| 3750 | 3750 | 4e91f | 115 115 |
| 3751 | 3751 | 75114 | 115 115 |
| 3752 | 3752 | 371f0 | 115 115 |
| 3753 | 3753 | e6200 | 115 115 |
| 3754 | 3754 | b1201 | 115 115 |
| 3755 | 3755 | cb431 | 115 115 |
| 3756 | 3756 | d5740 | 115 115 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)