This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
19964 | 19964 | cc5ed | 2581 2581 |
19965 | 19965 | 371f0 | 2581 2581 |
19966 | 19966 | e6200 | 2581 2581 |
19967 | 19967 | b1201 | 2581 2581 |
19968 | 19968 | 5f10e | 2581 2581 |
19969 | 19969 | 007df | 2581 2581 |
19970 | 19970 | d3539 | 2581 2581 |
19971 | 19971 | 60626 | 2581 2581 |
19972 | 19972 | 839f9 | 2581 2581 |
19973 | 19973 | ffca2 | 2581 2581 |
19974 | 19974 | 4f89e | 2581 2581 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )