This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
26747 | 26747 | cc5ed | 3239 3239 |
26748 | 26748 | 371f0 | 3239 3239 |
26749 | 26749 | e6200 | 3239 3239 |
26750 | 26750 | b1201 | 3239 3239 |
26751 | 26751 | 399e5 | 3239 3239 |
26752 | 26752 | d3539 | 3239 3239 |
26753 | 26753 | 4f89e | 3239 3239 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )