This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1591 | 1591 | b322d | 2800 2800 |
| 7806 | 7806 | b322d | 2796 2796 |
| 17326 | 17326 | b322d | 1120 1120 |
| 23836 | 23836 | b322d | 940 940 |
| 23984 | 23984 | b322d | 994 994 |
| 24208 | 24208 | b322d | 970 970 |
| 24923 | 24923 | b322d | 1017 1017 |
| 26241 | 26241 | b322d | 977 977 |
| 27234 | 27234 | b322d | 1037 1037 |
| 28326 | 28326 | b322d | 1060 1060 |
| 29327 | 29327 | b322d | 1172 1172 |
| 29817 | 29817 | b322d | 1154 1154 |
| 30317 | 30317 | b322d | 1089 1089 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)