This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 5848 | 5848 | 86f51 | 2888 2888 |
| 6297 | 6297 | 86f51 | 3001 3001 |
| 6549 | 6549 | 86f51 | 2893 2893 |
| 14748 | 14748 | 86f51 | 6 6 |
| 15392 | 15392 | 86f51 | 7 7 |
| 15676 | 15676 | 86f51 | 2885 2885 |
| 16017 | 16017 | 86f51 | 2884 2884 |
| 26568 | 26568 | 86f51 | 2886 2886 |
| 28520 | 28520 | 86f51 | 2889 2889 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)