This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 18923 | 18923 | cc5ed | 3257 3257 |
| 18924 | 18924 | ea4d7 | 3257 3257 |
| 18925 | 18925 | 2fe0c | 3257 3257 |
| 18926 | 18926 | 5e075 | 3257 3257 |
| 18927 | 18927 | 59d75 | 3257 3257 |
| 18928 | 18928 | e6200 | 3257 3257 |
| 18929 | 18929 | b1201 | 3257 3257 |
| 18930 | 18930 | 902e5 | 3257 3257 |
| 18931 | 18931 | 7dde7 | 3257 3257 |
| 18932 | 18932 | 26e0c | 3257 3257 |
| 18933 | 18933 | f3d24 | 3257 3257 |
| 18934 | 18934 | ff46e | 3257 3257 |
| 18935 | 18935 | 896d2 | 3257 3257 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)