This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16622 | 16622 | af0a7 | 2970 2970 |
| 17078 | 17078 | af0a7 | 2961 2961 |
| 17209 | 17209 | af0a7 | 2962 2962 |
| 21431 | 21431 | af0a7 | 2906 2906 |
| 25063 | 25063 | af0a7 | 2931 2931 |
| 26052 | 26052 | af0a7 | 2943 2943 |
| 26218 | 26218 | af0a7 | 2944 2944 |
| 29588 | 29588 | af0a7 | 2966 2966 |
| 29691 | 29691 | af0a7 | 2967 2967 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)