This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11290 | 11290 | eecd9 | 897 897 |
| 11383 | 11383 | eecd9 | 837 837 |
| 15295 | 15295 | eecd9 | 869 869 |
| 31590 | 31590 | eecd9 | 832 832 |
| 33446 | 33446 | eecd9 | 921 921 |
| 33672 | 33672 | eecd9 | 918 918 |
| 33701 | 33701 | eecd9 | 922 922 |
| 33746 | 33746 | eecd9 | 923 923 |
| 33789 | 33789 | eecd9 | 817 817 |
| 33832 | 33832 | eecd9 | 831 831 |
| 33875 | 33875 | eecd9 | 778 778 |
| 33931 | 33931 | eecd9 | 812 812 |
| 33988 | 33988 | eecd9 | 911 911 |
| 34007 | 34007 | eecd9 | 915 915 |
| 34264 | 34264 | eecd9 | 791 791 |
| 34320 | 34320 | eecd9 | 783 783 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)