This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 16010 | 16010 | cc5ed | 2884 2884 |
| 16011 | 16011 | 371f0 | 2884 2884 |
| 16012 | 16012 | e6200 | 2884 2884 |
| 16013 | 16013 | b1201 | 2884 2884 |
| 16014 | 16014 | 902e5 | 2884 2884 |
| 16015 | 16015 | 1d267 | 2884 2884 |
| 16016 | 16016 | 27bb6 | 2884 2884 |
| 16017 | 16017 | 86f51 | 2884 2884 |
| 16018 | 16018 | 0c5c0 | 2884 2884 |
| 16019 | 16019 | 179be | 2884 2884 |
| 16020 | 16020 | 041e4 | 2884 2884 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)