This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
14481 | 14481 | ec3ac | 1591 1591 |
14482 | 14482 | 6b827 | 1591 1591 |
14483 | 14483 | b825d | 1591 1591 |
14484 | 14484 | 5e075 | 1591 1591 |
14485 | 14485 | 59d75 | 1591 1591 |
14486 | 14486 | b1201 | 1591 1591 |
14487 | 14487 | 6a38c | 1591 1591 |
14488 | 14488 | 7ee91 | 1591 1591 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )