This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 10857 | 10857 | 94bdc | 112 112 |
| 11211 | 11211 | 94bdc | 1868 1868 |
| 11297 | 11297 | 94bdc | 897 897 |
| 11390 | 11390 | 94bdc | 837 837 |
| 12869 | 12869 | 94bdc | 1693 1693 |
| 15302 | 15302 | 94bdc | 869 869 |
| 15648 | 15648 | 94bdc | 3377 3377 |
| 15745 | 15745 | 94bdc | 3324 3324 |
| 17300 | 17300 | 94bdc | 3317 3317 |
| 18044 | 18044 | 94bdc | 3360 3360 |
| 31597 | 31597 | 94bdc | 832 832 |
| 33453 | 33453 | 94bdc | 921 921 |
| 33679 | 33679 | 94bdc | 918 918 |
| 33708 | 33708 | 94bdc | 922 922 |
| 33753 | 33753 | 94bdc | 923 923 |
| 33995 | 33995 | 94bdc | 911 911 |
| 34014 | 34014 | 94bdc | 915 915 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)