This data as json, CSV (advanced)
Link | rowid | target_id | ad_id |
---|---|---|---|
36061 | 36061 | cc5ed | 3510 3510 |
36062 | 36062 | fa635 | 3510 3510 |
36063 | 36063 | e6200 | 3510 3510 |
36064 | 36064 | b1201 | 3510 3510 |
36065 | 36065 | a48a7 | 3510 3510 |
36066 | 36066 | dfca7 | 3510 3510 |
36067 | 36067 | c30e5 | 3510 3510 |
36068 | 36068 | 33643 | 3510 3510 |
36069 | 36069 | a65c5 | 3510 3510 |
36070 | 36070 | e456e | 3510 3510 |
36071 | 36071 | aff2c | 3510 3510 |
36072 | 36072 | bbd8e | 3510 3510 |
36073 | 36073 | 8bae1 | 3510 3510 |
36074 | 36074 | 4bc77 | 3510 3510 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets ( target_id TEXT REFERENCES [targets]([id]), ad_id INTEGER REFERENCES [ads]([id]) )