This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 1862 | 1862 | ec3ac | 1086 1086 |
| 1863 | 1863 | 96bbd | 1086 1086 |
| 1864 | 1864 | 313af | 1086 1086 |
| 1865 | 1865 | ebe26 | 1086 1086 |
| 1866 | 1866 | 1073c | 1086 1086 |
| 1867 | 1867 | 4801f | 1086 1086 |
| 1868 | 1868 | 5e075 | 1086 1086 |
| 1869 | 1869 | 59d75 | 1086 1086 |
| 1870 | 1870 | e6200 | 1086 1086 |
| 1871 | 1871 | b1201 | 1086 1086 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)