This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 29856 | 29856 | ec3ac | 3283 3283 |
| 29857 | 29857 | 75744 | 3283 3283 |
| 29858 | 29858 | 371f0 | 3283 3283 |
| 29859 | 29859 | 5e075 | 3283 3283 |
| 29860 | 29860 | 59d75 | 3283 3283 |
| 29861 | 29861 | e6200 | 3283 3283 |
| 29862 | 29862 | b1201 | 3283 3283 |
| 29863 | 29863 | 902e5 | 3283 3283 |
| 29864 | 29864 | f0b0e | 3283 3283 |
| 29865 | 29865 | bd053 | 3283 3283 |
| 29866 | 29866 | 7f52f | 3283 3283 |
| 29867 | 29867 | bb729 | 3283 3283 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)