This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11289 | 11289 | 0593a | 897 897 |
| 11382 | 11382 | 0593a | 837 837 |
| 15294 | 15294 | 0593a | 869 869 |
| 33445 | 33445 | 0593a | 921 921 |
| 33671 | 33671 | 0593a | 918 918 |
| 33700 | 33700 | 0593a | 922 922 |
| 33745 | 33745 | 0593a | 923 923 |
| 33788 | 33788 | 0593a | 817 817 |
| 33831 | 33831 | 0593a | 831 831 |
| 33874 | 33874 | 0593a | 778 778 |
| 33930 | 33930 | 0593a | 812 812 |
| 33987 | 33987 | 0593a | 911 911 |
| 34006 | 34006 | 0593a | 915 915 |
| 34263 | 34263 | 0593a | 791 791 |
| 34319 | 34319 | 0593a | 783 783 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)