This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
36004 | 36004 | fa635 | 3513 3513 |
36018 | 36018 | fa635 | 3509 3509 |
36041 | 36041 | fa635 | 3508 3508 |
36062 | 36062 | fa635 | 3510 3510 |
36085 | 36085 | fa635 | 3514 3514 |
36145 | 36145 | fa635 | 3512 3512 |
36159 | 36159 | fa635 | 3506 3506 |
36287 | 36287 | fa635 | 3507 3507 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )