This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
2878 | 2878 | 9eadd | 743 743 |
2879 | 2879 | 0b28b | 743 743 |
2880 | 2880 | 72f3e | 743 743 |
2881 | 2881 | 24202 | 743 743 |
2882 | 2882 | 371f0 | 743 743 |
2883 | 2883 | 5e075 | 743 743 |
2884 | 2884 | 59d75 | 743 743 |
2885 | 2885 | e6200 | 743 743 |
2886 | 2886 | b1201 | 743 743 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )