This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 13928 | 13928 | b343d | 1644 1644 |
| 13929 | 13929 | b14b0 | 1644 1644 |
| 13930 | 13930 | 2100a | 1644 1644 |
| 13931 | 13931 | a4fb7 | 1644 1644 |
| 13932 | 13932 | 0733f | 1644 1644 |
| 13933 | 13933 | a30e4 | 1644 1644 |
| 13934 | 13934 | 5e075 | 1644 1644 |
| 13935 | 13935 | a4abf | 1644 1644 |
| 13936 | 13936 | 59d75 | 1644 1644 |
| 13937 | 13937 | e6200 | 1644 1644 |
| 13938 | 13938 | b1201 | 1644 1644 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)