This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
33680 | 33680 | ec3ac | 909 909 |
33681 | 33681 | 1c31d | 909 909 |
33682 | 33682 | 5e075 | 909 909 |
33683 | 33683 | 59d75 | 909 909 |
33684 | 33684 | e6200 | 909 909 |
33685 | 33685 | b1201 | 909 909 |
33686 | 33686 | 9faf6 | 909 909 |
33687 | 33687 | e7597 | 909 909 |
33688 | 33688 | 13f83 | 909 909 |
33689 | 33689 | ecb59 | 909 909 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )