This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
5324 | 5324 | 48e80 | 2375 2375 |
5325 | 5325 | 4801f | 2375 2375 |
5326 | 5326 | 5e075 | 2375 2375 |
5327 | 5327 | 59d75 | 2375 2375 |
5328 | 5328 | 4accc | 2375 2375 |
5329 | 5329 | b1201 | 2375 2375 |
5330 | 5330 | d003e | 2375 2375 |
5331 | 5331 | a340a | 2375 2375 |
5332 | 5332 | 18a64 | 2375 2375 |
5333 | 5333 | 9295b | 2375 2375 |
5334 | 5334 | 31177 | 2375 2375 |
5335 | 5335 | 7c38f | 2375 2375 |
5336 | 5336 | 7ee91 | 2375 2375 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )